| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using vlookup within an if statement
I am trying to accomplish a vlookup within the IF statement but it won't work
=IF(VLOOKUP(A2,RPT7571!B:I,4,FALSE)="2",VLOOKUP(A2 ,RPT7571!B:I,5,FALSE),"") I have 2 spreadsheets with info. I am trying to say in a cell in spreadsheet 1 - look into speadheet RPT7571 and if A2 matches A2 in my spreadsheet 1 then look over 4 columns and if the 4th column has a value of 2 then return the value in column 5 of the RPT7571 spreadsheet into my spreadsheet 1 otherqise return nothing. It does not work Help -- Thanks ETC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement with VLookup | Excel Worksheet Functions | |||
| Nested IF statement with VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup 'And' statement | Excel Discussion (Misc queries) | |||
| Vlookup or If statement Help | Excel Worksheet Functions | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Threaded Mode
