Enter this formula in D1 of Sheet1:

=IF(ISNA(MATCH(A1,Sheet2!$A$1:$A$5,0)),"",VLOOKUP( A1,Sheet2!$A$1:$B$5,2,0))

And copy down as needed.

If the formula doesn't find a match on Sheet2, it'll return a blank cell.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"berna" wrote in message
...
In the sheet ! i have

A B C
onions 23 123
carpent 45 124
red pepper 198 125
tomatos 22 156

In the sheet 2 i have

A B
onions holland
carpent greece
garlic portugal
red pepper spain
tomatos spain


So i want to complete my list in the sheet one column D like this


A B C D
onions 23 123 holland
carpent 45 124 greece
red pepper 198 125 spain
tomatos 22 156 spain
garlic 34 234 portugal


So there is a way to do this?
please note list 1 and list 2 dont match in the row order!!

Thanks again





"Ragdyer" wrote:

What columns and rows contain the name of the countries?
What columns and rows contain the name of the *corresponding* elements?
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"marcuse" wrote in message
...
hi
thanks for the answer
how i should do that database?

I have a list of both elements just one in front of the other cell in
the
sheet2!!

"RagDyeR" wrote:

You must have a datalist somewhere that establishes the relationship
between
Holland and Red Pepper, and Greece and Onions & Tomatoes.

Depending on the configuration of this "relationship" list, you can
use
either Vlookup() or an Index() and Match() combination.

If you want help, you must post where and how this list is set-up.
--

Regards,

RD


--------------------------------------------------------------------------
---------------------
Please keep all correspondence within the Group, so all may benefit
!


--------------------------------------------------------------------------
---------------------

"berna" wrote in message
...
Hello everyone
I have a list o words linked with others; list, filter or watherever
for example

onions 23 34
carpent 12 14
red pepper 45 48...

and i have another list like this in another sheet

holland
greece...

there is always a relation beteween for example red pepper and his
data
and
holland, so i want to linked in the sheet to complete my list and
make a
selection like in this case by country; I know it should be easy but
i
can t
find the answer in this amazing forum,

so i want this one
greece onions 23 34
greece tomatos 12 14
holland red pepper 45 48...

Thanks beforehand