link words from one list to another and complete the list

[berna]

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

 

[RagDyeR]

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 !
-----------------------------------------------------------------------------------------------

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

 

[marcuse]

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]

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

 

[berna]

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]

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.