Excel rookie need help with drop down lists

Create a vlookup table (could be done hardcoded as well), lets

say your dropdown value is in B1

=IF(B1="","",VLOOKUP(B1,Table,2,0)

for simplicity in the explanation the dropdown values

are a, b, c, the values are 20, 30, 40 then it would look like

=IF(B1="","",VLOOKUP(B1,{"a",20;"b",30;"c",40},2,0))

so if you select "c" from the dropdown the formula will return 40

--

Regards,

Peo Sjoblom

Quote:

> I have a spreadsheet where I have 3 columns, each with 3 choices of data -

I

> have validated these so you have a drop down choice when selecting the

cell.

> What I want to do is create a numeric value dependant on the choices made

in

> the three columns and then take that value & use it in a formula to

achieve

> a further result - I have the values (27 I think!) I just do not know how

to

> get the spreadsheet to come up with the answer after a choice has been

made.

> Does that make sense?

> Any help would be greatly appreciated.

> Cheers

> Fec