Hi
try:
=VLOOKUP(A15,'Z:\[stock.xls]6064'!$A9:$D2504,4,TRUE)
or if you look for an exact match use:
=VLOOKUP(A15,'Z:\[stock.xls]6064'!$A9:$D2504,4,FALSE)
"Josef.angel" wrote:
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
|