Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 29th 04, 07:39 AM
Josef.angel
 
Posts: n/a
Default 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   Report Post  
Old October 29th 04, 07:42 AM
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Old October 29th 04, 08:06 AM
Josef.angel
 
Posts: n/a
Default

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   Report Post  
Old October 29th 04, 08:16 AM
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Old October 29th 04, 08:41 AM
Josef.angel
 
Posts: n/a
Default

=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   Report Post  
Old October 29th 04, 08:41 AM
Josef.angel
 
Posts: n/a
Default

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   Report Post  
Old October 29th 04, 08:47 AM
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Old October 29th 04, 08:50 AM
Josef.angel
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup finds a blank, but returns a zero - HELP! flummoxed Excel Discussion (Misc queries) 6 January 18th 05 04:15 PM
Vlookup Syntax Error YV New Users to Excel 9 December 23rd 04 06:28 PM
#N/A error with VLOOKUP Michelle Tucker Excel Discussion (Misc queries) 4 December 14th 04 02:23 PM
Need help with modifying VLookUp Tom Excel Discussion (Misc queries) 4 December 2nd 04 01:44 AM
Vlookup with VBA Jeff Excel Discussion (Misc queries) 8 December 1st 04 03:41 PM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017