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.
Bookmarks