| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I use =if with vlookup statements
I would like to use an if statement to fill in data in one column - I have 1
lookup table with 6 columns and a spreadsheet with multiple columns - basically I want to ask if a cell=13 go to my look up table"res type" A$2:$B$220 if not go to the same lookup table but go to E$2:$F$220 this is what I wrote but it is not working: =IF(S222=13,VLOOKUP(V222,'RES TYPE'!E$2:$F$220,6,FALSE),VLOOKUP(S222,'RES TYPE'!A$2:$B$220,2,FALSE)) I could really use some help - thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup and if statements | New Users to Excel | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| VLOOKUP + IF STATEMENTS | Excel Discussion (Misc queries) | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| VLOOKUP statements | Excel Discussion (Misc queries) | |||
Threaded Mode
