| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
link words from one list to another and complete the list
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
link words from one list to another and complete the list
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
link words from one list to another and complete the list
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
link words from one list to another and complete the list
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
link words from one list to another and complete the list
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get a complete list of All my EXCEL files? | Excel Discussion (Misc queries) | |||
| auto complete in list | Excel Discussion (Misc queries) | |||
| Auto complete in a validation list | Excel Discussion (Misc queries) | |||
| How to get the complete list Excel Worksheet Functions | Excel Worksheet Functions | |||
| Auto-complete an entry in drop-down list | New Users to Excel | |||
Linear Mode
