View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
berna berna is offline
external usenet poster
 
Posts: 2
Default link words from one list to another and complete the list

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