| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup returns #N/A correctly...but...
Hi All,
I am using the Vlookup formula to compare two files daily extractions. The #N/A value is retuned when there is correctly no match found. I want to create a formula in a seperate column, based on the results of the Vlookup, that would return a text string based on those results. IF statements work great except for the #N/A results. I have tried IF(ISNA(cell ref),"XYZ","ABC") and it still uses #N/A as a result of the IF. Any suggestions would be greatly appreciated! -- Linda |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup returns #N/A correctly...but...need formula in another col | Excel Worksheet Functions | |||
| excel vlookup not working correctly | Excel Worksheet Functions | |||
| vlookup isn't working correctly? | Excel Discussion (Misc queries) | |||
| formula returns (correctly) a negative value | Excel Discussion (Misc queries) | |||
| Array not working correctly Returns FALSE on second part | Excel Discussion (Misc queries) | |||
Threaded Mode
