so dou you mean something like
value",VLOOKUP(40,'Z:\[stock.xls]6064'!$A9:$D2504,4,TRUE),"A15 is something
i've tried doing that. & I get #n/a. value not available
the vlookup is directing it to lookup 40 specifically in the separate
I want it to only do that after it finds out what is in A15 in this document
Can you tell me how you reference a cell within a worksheet within a
workbook - brackets, quotes etc.
"Frank Kabel" wrote:
or if you look for an exact match use:
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.
trying to substitute 40 with a nested index without success.