| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Vlookup doesn't work until i edit(but not change) the lookup cell
I am using vlookup to lookup values in data copied from a CSV file. It first
returned #N/A so i changed the Number Format (of the Lookup_Value) to "Text" and it still returned #N/A but when i pressed F2 and then enter (on the Lookup_Value cell), the vlookup returned the correct value. This is really driving me up the wall, can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert VLOOKUP to absolute cell reference | Excel Discussion (Misc queries) | |||
| Return cell reference of lookup value | Excel Worksheet Functions | |||
| Look for change next blank cell in Range | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
