|
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 |
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 |
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 |
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 |
=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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 12:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com