Merging data from two worksheets

[Eddie Gonzalez]

I have two worksheets with lists on them. On worksheet A there are items we
use, and charge code (which correspond to individual items); but there is no
RMS code (a specific code we use for our system). On worksheet B there is a
larger list of items, many of which are also on worksheet A. Worksheet B has
a column with the same charge codes as are used in worksheet A, but worksheet
B has the corresponding RMS codes.

For example...
On A:
Item RMS Charge Code
Stick (blank) 12345
Ball (blank) 54321
Bases (blank) 21543

On B:
Item RMS Charge Code
Stick 123 12345
Grass 231 13524
Ball 213 54321
Hats 333 55543
Bases 222 21543

What I need to do is merge these two lists. My list has about 654 individual
items to go thru. I am looking for a simpler way than doing each row
individually, filling in the missing RMS code. I have been able to compare
the two lists and have Excel show which items were and were not on the other
lists. But, I still need to get that RMS code filled into the blank slot in
the other list.

Thanks.

 

[Dave Peterson]

This sounds like a job for .... =Vlookup()

Debra Dalgleish has some very nice instructions at:

http://www.contextures.com/xlFunctions02.html