| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If & Vlookup statement
I am trying to lookup 2 separate ranges based on the IF statement.
For example If B3="PWR-PHYS" then I need it to lookup(A3,'DatePivot'!A1:B20,2) But if B3 does not = "PWR-PHYS", then i need it to lookup(A3,'Location'!A1:B20,2) So whether it equals pwr-phys or doesnt, I need a value returned from separate locations. Please advise how I can do this |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup, if statement, maybe an and statement | Excel Discussion (Misc queries) | |||
| Help with If and Vlookup Statement | Excel Worksheet Functions | |||
| Vlookup or IF statement | Excel Worksheet Functions | |||
| if then statement (i think) or vlookup | Excel Worksheet Functions | |||
| Vlookup or If statement Help | Excel Worksheet Functions | |||
Threaded Mode
