Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
case of
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
case of
Have a look in the help index for LOOKUP for VLOOKUP
-- Don Guillett Microsoft MVP Excel SalesAid Software "MrWonder" wrote in message ... 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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
case of
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 --- "MrWonder" wrote: 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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
case of
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) -- Thanks, Shane Devenshire "MrWonder" wrote: 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change data of entire column from small case to upper case | Excel Worksheet Functions | |||
How do I change from upper case to proper case in excel 2002 | Excel Discussion (Misc queries) | |||
Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
excel'03 how to convert a column from upper case to proper case | Excel Discussion (Misc queries) | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) |