VLOOKUP Question

[Guest]

Not a very knowledgeable Excel 2003 user, but - I am trying to lookup a value
from column B2:B415 in worksheet 1 and trying to find the matching value in
worksheet2, column A2:A415. I would like the value in the next column in
worksheet 2 to be returned to the column in worksheet 1 where I am entering
the value. What is returned is the same value I am looking for:

=VLOOKUP(B2,'[EDI Vendors and Maps.xls]Sheet1'!$A$2,1,FALSE)

First value is 2 and finds match and returns 2, when I want the value in the
second column. I know I am doing something stupid, so all help would be
greatly appreciated.

Thanks from a frustrated user - Rich

 

[Guest]

Hi,

The correct formula is:
=VLOOKUP(B2,'[EDI Vendors and Maps.xls]Sheet1'!$A$2:$A$415,1,FALSE)

Thanks,

 

[Dave Peterson]

Maybe...

=VLOOKUP(B2,'[EDI Vendors and Maps.xls]Sheet1'!$A$2:$b$415,2,FALSE)

This will look for a match between B2 of the activesheet and sheet1's A2:A415.
If a match is found, it'll return the value in column B of that sheet1.

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) here:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

(The second page (for index(match())) is nice when the key column is to the
right of the data to be retrieved.)

Not a very knowledgeable Excel 2003 user, but - I am trying to lookup a value
from column B2:B415 in worksheet 1 and trying to find the matching value in
worksheet2, column A2:A415. I would like the value in the next column in
worksheet 2 to be returned to the column in worksheet 1 where I am entering
the value. What is returned is the same value I am looking for:

=VLOOKUP(B2,'[EDI Vendors and Maps.xls]Sheet1'!$A$2,1,FALSE)

First value is 2 and finds match and returns 2, when I want the value in the
second column. I know I am doing something stupid, so all help would be
greatly appreciated.

Thanks from a frustrated user - Rich

 

[Guest]

That still returned a value of 2 in the cell - I see that you just changed
the range from the worksheet that I was checking against, but that did not
give me my desired result.

Hi,

The correct formula is:
=VLOOKUP(B2,'[EDI Vendors and Maps.xls]Sheet1'!$A$2:$A$415,1,FALSE)

Thanks,
--
Farhad Hodjat

Not a very knowledgeable Excel 2003 user, but - I am trying to lookup a value
from column B2:B415 in worksheet 1 and trying to find the matching value in
worksheet2, column A2:A415. I would like the value in the next column in
worksheet 2 to be returned to the column in worksheet 1 where I am entering
the value. What is returned is the same value I am looking for:

=VLOOKUP(B2,'[EDI Vendors and Maps.xls]Sheet1'!$A$2,1,FALSE)

First value is 2 and finds match and returns 2, when I want the value in the
second column. I know I am doing something stupid, so all help would be
greatly appreciated.

Thanks from a frustrated user - Rich

 

[Guest]

BINGO - Thanks for your help - I know I can count on the experts in here.

I hope all have a great weekend and thanks once more.

Maybe...

=VLOOKUP(B2,'[EDI Vendors and Maps.xls]Sheet1'!$A$2:$b$415,2,FALSE)

This will look for a match between B2 of the activesheet and sheet1's A2:A415.
If a match is found, it'll return the value in column B of that sheet1.

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) here:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

(The second page (for index(match())) is nice when the key column is to the
right of the data to be retrieved.)

Not a very knowledgeable Excel 2003 user, but - I am trying to lookup a value
from column B2:B415 in worksheet 1 and trying to find the matching value in
worksheet2, column A2:A415. I would like the value in the next column in
worksheet 2 to be returned to the column in worksheet 1 where I am entering
the value. What is returned is the same value I am looking for:

=VLOOKUP(B2,'[EDI Vendors and Maps.xls]Sheet1'!$A$2,1,FALSE)

First value is 2 and finds match and returns 2, when I want the value in the
second column. I know I am doing something stupid, so all help would be
greatly appreciated.

Thanks from a frustrated user - Rich