| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOK up returning #N/A even though value exists in lookup array
You may want to share the formula.
And look at Debra Dalgleish's site for troubleshooting your =vlookup() formula: http://contextures.com/xlFunctions02.html#Trouble wrote: 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 -- Dave Peterson |
| Reply |
| 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 | |||
Linear Mode
