| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
vlookup formulas returning no values
just upgraded to excel 2003.....yesterday my formulas worked, today they
dont. here is the formula I am using : =IF(ISNA(VLOOKUP(A6,'OTC AUTEX'!$D$1:$H$179,3,FALSE)),"",VLOOKUP(A6,'OTC AUTEX'!$D$1:$H$179,3,FALSE)) It should return values to the current sheet from the OTC AUTEX sheet, but I am getting nothing. I tried F9 to refresh, and got nothing. Any thoughts? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP not returning results | Excel Worksheet Functions | |||
| Comparing text and returning boolean values | Excel Discussion (Misc queries) | |||
| VLookup for multiple values!! | Excel Worksheet Functions | |||
| VLOOKUP returning LAST match | Excel Discussion (Misc queries) | |||
| Vlookup returning #N/A | Excel Worksheet Functions | |||
Threaded Mode
