Matching data from one table and copy them to another

K

KostaM

Hi,
I have two Excel tables. Table 1 contains list of animals and their
description in two columns. Table 2 contains list of animals and results of a
test. Not all animals from Table 1 mach the animals in Table 2, but most of
them do. I have to link those two tables in a way that test result from table
2 appears in Table 1 Column 3 but of course I must use animal ID column as a
reference to match data. How can I do this?
 
A

Aladin Akyurek

It's always a good idea to reveal ranges... That said...

Table1 = A2:B100

Table2 = F2:G200

In D2 enter & copy down:

=MATCH(A2,$F$2:$F$100,0)

In C2 enter & copy down:

=IF(ISNUMBER(D2),INDEX($G$2:$G$200,C2),"")
 
Top