how to extract information from one table to another one

[Omics]

Question:

For the example below, if one would extract the “Food†information from
Table 2 and put it to the corresponding “Food†column in Table 1, what’s the
best way to do this? Is there a way without using macro?

The expecting result for the example below
Area Food
AA apple
BB orange
CC cherry
DD banana

My real data has more than 10,000 rows. Thus I would very much appreciate
your help.

Omics


Example:
Table 1

Area Food
AA
BB
CC
DD



Table 2
Area Food Store

AA apple x
AA apple y
AA apple z
DD banana 3
DD banana m
BB orange 1
CC cherry 10
FF potato v
GG peanut s
GG peanut a
HH fish 6
BB orange j
EE tomato l
EE tomato 8

 

[Omics]

Thanks. Tried it but it said formula error.

Omics

 

[Omics]

Thanks so much, Janusz and David! It finally worked out by using following
formula:
=VLOOKUP('1'!A1, '2'!A:B,2,FALSE)

Omics