| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOK up returning #N/A even though value exists in lookup array
I've had this problem before and it was fixed when I'd sort the lookup
array in ascending order. Did that, still no good. I've also made sure both fields were text. Still no good. But when I copy the value being looked up, and do a find for it in the lookup array, it is found - but I get #N/A with teh formula. Any thoughts? Cheers, Shaun |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
| VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
| Returning an address from an array | Excel Discussion (Misc queries) | |||
| Lookup value - see if exists in another array | Excel Worksheet Functions | |||
| need array of true/false if text exists | Excel Worksheet Functions | |||
Threaded Mode
