Thread: Vlookup - indexing View Single Post
#8
October 29th 04, 08:50 AM
 Josef.angel Posts: n/a

got it.
=VLOOKUP(ConsignedMaterials!\$A21,'[rb Consignment Stock Sales
play.xls]6064'!\$A\$5:\$D\$2500,4,TRUE)

but cells were formatted to 8 digit numbers
00000064
to
64
was the final key to retun required info.

thanks

"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
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