Lookup by Last Column

N

Nash13

I have a lookup that doesn't work unless I move the last column of the sheet
being looked up to the first column. How can I get it to look by the last
column? Unfortunately it is another workbook and can't be moved. I have my
current example below. Thanks

=VLOOKUP($A$4,[SalesNumbersConsumer4.20.07.xls]WkQA!$A$1:$R$1000,4,FALSE)
 
D

Dave Peterson

You could use =index(match())

Kind of like this within the same workbook:
=index(sheet2!a:a,match(a1,sheet2!r:r,0))

Debra Dalgleish shares more info:
http://www.contextures.com/xlFunctions03.html


I have a lookup that doesn't work unless I move the last column of the sheet
being looked up to the first column. How can I get it to look by the last
column? Unfortunately it is another workbook and can't be moved. I have my
current example below. Thanks

=VLOOKUP($A$4,[SalesNumbersConsumer4.20.07.xls]WkQA!$A$1:$R$1000,4,FALSE)
Click to expand...
 
N

Nash13

If I define the range, how do I look up by it? Thanks

Don Guillett said:
You might try a defined name referring to the range in the other workbook.

--
Don Guillett
SalesAid Software
[email protected]
Nash13 said:
I have a lookup that doesn't work unless I move the last column of the
sheet
being looked up to the first column. How can I get it to look by the last
column? Unfortunately it is another workbook and can't be moved. I have my
current example below. Thanks

=VLOOKUP($A$4,[SalesNumbersConsumer4.20.07.xls]WkQA!$A$1:$R$1000,4,FALSE)
Click to expand...
Click to expand...
 
N

Nash13

Dave, I copied each of the examples from that web page into Excel and none
seem to work. Am I missing something?

Dave Peterson said:
You could use =index(match())

Kind of like this within the same workbook:
=index(sheet2!a:a,match(a1,sheet2!r:r,0))

Debra Dalgleish shares more info:
http://www.contextures.com/xlFunctions03.html


I have a lookup that doesn't work unless I move the last column of the sheet
being looked up to the first column. How can I get it to look by the last
column? Unfortunately it is another workbook and can't be moved. I have my
current example below. Thanks

=VLOOKUP($A$4,[SalesNumbersConsumer4.20.07.xls]WkQA!$A$1:$R$1000,4,FALSE)
Click to expand...
Click to expand...
 
N

Nash13

Okay, I got it. Thanks guys.

Don Guillett said:
You might try a defined name referring to the range in the other workbook.

--
Don Guillett
SalesAid Software
[email protected]
Nash13 said:
I have a lookup that doesn't work unless I move the last column of the
sheet
being looked up to the first column. How can I get it to look by the last
column? Unfortunately it is another workbook and can't be moved. I have my
current example below. Thanks

=VLOOKUP($A$4,[SalesNumbersConsumer4.20.07.xls]WkQA!$A$1:$R$1000,4,FALSE)
Click to expand...
Click to expand...
 
D

Don Guillett

The archives would like to know what you used.

--
Don Guillett
SalesAid Software
[email protected]
Nash13 said:
Okay, I got it. Thanks guys.

Don Guillett said:
You might try a defined name referring to the range in the other
workbook.

--
Don Guillett
SalesAid Software
[email protected]
Nash13 said:
I have a lookup that doesn't work unless I move the last column of the
sheet
being looked up to the first column. How can I get it to look by the
last
column? Unfortunately it is another workbook and can't be moved. I have
my
current example below. Thanks

=VLOOKUP($A$4,[SalesNumbersConsumer4.20.07.xls]WkQA!$A$1:$R$1000,4,FALSE)
Click to expand...
Click to expand...
Click to expand...
 
Top