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.

"Dave Peterson" wrote:

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()) he
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.)

Rich K. wrote:

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

--

Dave Peterson