| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with Match Not Working
Can someone tell me why this keeps returning a #N/A error when it shouldn't.
I'm using match to find the lookup value. On its own, the "G"&MATCH(B11,$G$5:$G$780,0)+4 portion of the formula correctly evaluates to G29, but when used in the vlookup, it gives me #N/A. =VLOOKUP("G"&MATCH(B11,$G$5:$G$780,0)+4,$G$5:$I$78 0,2,FALSE) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp or HLookUp Plus Index - Match, I think??? | Excel Worksheet Functions | |||
| Tricky ... Pullout related rows that match a single word using Vlookup | Excel Discussion (Misc queries) | |||
| can vlookup be forced to make a case sensitive match? | Excel Discussion (Misc queries) | |||
| Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
| Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Threaded Mode
