| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
if and vlookup functions
I need to do a function that will look for one of three criterion in a cell,
if condition a,b, or c is met, then I need to lookup a person's name and then assign them to a team. So far I've tried the following formulae, but it turns up NA or TRUE. =if(f96="teamA"),vlookup(a96,TeamA!$a$4:$f$100,3,f alse), if(f96="teamB"),vlookup(a96,TeamB!$a$4:$f$100,3,fa lse), if(f96="teamC"),vlookup(a96,TeamC!$a$4:$f$100,3,fa lse) Please advise as I'm quite new to this. Regards. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using VLOOKUP, IF and RIGHT functions together | Excel Worksheet Functions | |||
| Combining VLOOKUP functions | Excel Worksheet Functions | |||
| VLOOKUP and logical functions | Excel Worksheet Functions | |||
| if statements depending on multiple VLOOKUP functions | Excel Discussion (Misc queries) | |||
| Embedding functions in Vlookup? | Excel Worksheet Functions | |||
Threaded Mode
