matching data from different tables with similar columns

[marksuza]

HI, I am having some trouble with matching some data and I was wonderin
if anybody could help me? I have two tables with the columns "Name" an
"Amount", the first table has the column "Names" field but the colum
"Amount" empty. I wanted to fill the "Amount" column in the firs
table based on the second table, the problem is that the second tabl
has many more records than the first. Is there a way to create
formula to look up the name on second table and "amount" data on th
first table. Thanks for the help.

Regards,

Marco

 

[Mike Lewis]

Try the VLOOKUP function.

In the first table enter in the amount column the formula:

=VLOOKUP(D16,table_two_range,2,FALSE)
where d16 is the cell that contains the name and make sure
the table 2 range is "absolute" with $ signs - like
$D$12:$E$200.

Then copy that formula down, and "copy and paste special
values" if you want to "lock in the values"

Good luck

Mike

 

[mzehr]

Hi Marcos,
try using something like
Assume that table 1 is on sheet1 in columns A and B
and table 2 is on sheet2 in columns A and B
SUMIF(Sheet2!A:A,Sheet1!A1,Sheet2!B:B))
put that in your amount column

A better solution might be to use a pivot table to
summarize the data.

HTH