Adding columns given a match

[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

 

[JBeaucaire]

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

 

[Jay Emory]

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

 

[Herbert Seidenberg]

Excel 2007
Tables with Structured References:
http://www.mediafire.com/file/jbmjnzm2mni/03_27_09.xlsx

 

[Cefoxtrot]

Jay, that worked! Thank you so much!
Cefoxtrot

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