You'll need to use either commas or semi-colons, depending on what you use
as your list separator (specfied in Windows Regional Options), but not a
mixture of the two. :-(
--
David Biddulph

"Omics" wrote in message
...

Thanks. Tried it but it said formula error.

Omics

"Janusz Pawlinka" wrote:

U¿ytkownik "Omics" napisa³ w wiadomo¶ci
...
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.



I assume that Table1 and Table2 are separate worksheets in the same
workbook,
and Area and Food are columns A and B in these worksheets.

In Table1 column Food cell B1 try this (when A1 ie AA)
=VLOOKUP(A1, Table1!A:B;2;FALSE)
and then copy that formula down below

This works fime when there is one Food for one Area. When there is more
than
one
Food for one Area (ie apple and pear for AA) - formula returns that value
which is first
founded (when first apple is in row 24 and first pear in column 36 -
formula
returns apple).

--
==============================
Janusz Pawlinka