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 
#2




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 
#3




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 
#4




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 
#5




=VLOOKUP(ConsignedMaterials!A21,'Z:\[rb Consignment Stock Sales
play.xls]6064'!$A$5:$D$2500,4,TRUE) this has recognised my cell reference in my current document but i'm still getting a value not available error. "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 
#6




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




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 
#8




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 & removing the additional zeros 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 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 
Reply 
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) 