Lookup by Last Column

[Guest]

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)

 

[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)

 

[Don Guillett]

You might try a defined name referring to the range in the other workbook.

 

[Guest]

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

You might try a defined name referring to the range in the other workbook.

--
Don Guillett
SalesAid Software
(e-mail address removed)

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)

 

[Guest]

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

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)

 

[Guest]

Okay, I got it. Thanks guys.

You might try a defined name referring to the range in the other workbook.

--
Don Guillett
SalesAid Software
(e-mail address removed)

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)

 

[Don Guillett]

The archives would like to know what you used.

--
Don Guillett
SalesAid Software
(e-mail address removed)

Okay, I got it. Thanks guys.

You might try a defined name referring to the range in the other
workbook.

--
Don Guillett
SalesAid Software
(e-mail address removed)

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)