Hi Josef
to be honest your requirement description is confusing. Please try the
following
 describe exactly what is on what sheet. You may even post some example data
 describe exactly what you're trying to lookup
I personally don't know what cell A15 is or what values you have on your
other sheets. And I don't get what you mean with:
"the A15 is on sheet1 called consignedmaterial of 3 different sheets"
Is it on sheet one or is it in three different sheets?
"Josef.angel" wrote:
sort of.. BUT the A15 is on sheet1 called consignedmaterial of 3 different
sheets
and the if document is the one with the formula in it called index
BUT 2  i don't want to type in the 40 thats what i'm trying to looking up
first.
the "if almost has to be inside the lookup where the 40 is.
=IF('Z:\[index.xls]6064'!A15="some
value",VLOOKUP(40,'Z:\[stock.xls]6064'!$A9:$D2504,4,TRUE),"A15 is something
else")
"Frank Kabel" wrote:
Hi
so dou you mean something like
=IF('Z:\[stock.xls]6064'!A15="some
value",VLOOKUP(40,'Z:\[stock.xls]6064'!$A9:$D2504,4,TRUE),"A15 is something
else")
"Josef.angel" wrote:
i've tried doing that. & I get #n/a. value not available
the vlookup is directing it to lookup 40 specifically in the separate
spreadsheet.
I want it to only do that after it finds out what is in A15 in this document
first
Can you tell me how you reference a cell within a worksheet within a
workbook  brackets, quotes etc.
"Frank Kabel" wrote:
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
