| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Vlookup - indexing
Hi all
instead of asking the formula to lookup 40 in the secondary document directly I'm wanting to base my lookup on the value in a cell that is in the same row as the formula. =VLOOKUP(40,'Z:\[stock.xls]6064'!$A9:$D2504,4,TRUE) trying to substitute 40 with a nested index without success. =VLOOKUP([index(A15)],'Z:\[Consignment Stock qty.xls]6064'!$A$5:$D$2500,4,TRUE) thanks Josef.angel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
| Vlookup Syntax Error | New Users to Excel | |||
| #N/A error with VLOOKUP | Excel Discussion (Misc queries) | |||
| Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
| Vlookup with VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
