case of

[MrWonder]

When I want to make a choice in a list and in each case there must be another
result how do I manage? (The if-function works only for one case)

 

[Don Guillett]

Have a look in the help index for LOOKUP for VLOOKUP

 

[Max]

You can use vlookup set to exact match, to lookup the droplist selections (in
say, A1 down) and have the results returned in an adjacent col (eg in B1 down)

Try Debra's page on VLOOKUP essentials:
http://www.contextures.com/xlFunctions02.html
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik

 

[ShaneDevenshire]

If you mean by this that if you pick an item from a data validation drop down
list you want another cell, somewhere else, you want a formula to return a
different answer:

1. You can use IF with more than one conditon, for example if A1 is where
your list is:

=IF(A1="red",15,IF(A1="Green",20,0))

2. You can use VLOOKUP, HLOOKUP, LOOKUP, or MATCH, for example:
If you set up a little table

red 15
green 20

then
=VLOOKUP(A1,LittleTable,2,FALSE)

3. You can use CHOOSE, for example:

=CHOOSE(MATCH(A1,{"red","green"},0),15,20)