Hi,

I'm trying to replace a value across two sheets based on a match in
another column between the two sheets. What I have is sheet1 with two
columns, the first is a vendor and the second an ID number.
A B
Hone 420
Cope 347
Fara 14
In sheet2, I have the same values in column A, but the value in column
B may or may not be different. Also the value in col A may be
repetitive.
A B
Hone 420
Hone 421
Hone 421
Cope 345
Cope 345
Fara 14

What I want to do is find all the values in sheet2 Col A that match
sheet1 Col A and then drop in the value in Col B from sheet1 into
sheet2. The masterlist contains 40000 lines and sheet 2 contains only
16000. Sheet2 may not have all values in col A that are in Col A of
sheet1. I'm thinking VLOOKUP, but I'm unsure how to write the formula.
Any help would be great. Thanks.


--
researcy
------------------------------------------------------------------------
researcy's Profile: http://www.excelforum.com/member.php...o&userid=31948
View this thread: http://www.excelforum.com/showthread...hreadid=516849