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, whats 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