Adding columns given a match

  • Thread starter Thread starter Cefoxtrot
  • Start date Start date
C

Cefoxtrot

Hello,

I have 2 tables with different data, except for a member ID column.

Table A has 38,000 records with about 35 columns. Table B has 3,000 records,
with about 9 columns.
I need to read table B, scan table A with the member ID from table B and add
the 3 last cells from table B to table A for that member.

I have a general idea how to do it, but that's about it. I need help.
Any suggestions will be greatly appreciated.
Thanks much in advance,
Cefoxtrot
 
Simplest technique is INDEX/MATCH.

This link will probably be broken by the forum, but remove the breaks to
make one long line again and it shows my brief explanation of INDEX/MATCH:

http://www.excelforum.com/excel-general/
676832-match-two-cells-composed-of-
text-in-the-same-row.html#3
 
The Vlookup function will return values to Table A from Table B assuming
there are no duplicate member ID's in Table B. If, however, you are trying
to preserve those values in Table A and append data when a new Table B is
introduced you have a much different task ahead.

hth,
jay
 
Jay, that worked! Thank you so much!
Cefoxtrot


Jay Emory said:
The Vlookup function will return values to Table A from Table B assuming
there are no duplicate member ID's in Table B. If, however, you are trying
to preserve those values in Table A and append data when a new Table B is
introduced you have a much different task ahead.

hth,
jay
Click to expand...
 
Back
Top