 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / December 2007link 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 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.  SignatureRegards, 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 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!! > You must have a datalist somewhere that establishes the relationship between > Holland and Red Pepper, and Greece and Onions & Tomatoes. [quoted text clipped - 27 lines] > > Thanks beforehand What columns and rows contain the name of the countries? What columns and rows contain the name of the *corresponding* elements? SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > hi > thanks for the answer [quoted text clipped - 40 lines] > > > > Thanks beforehand 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 > What columns and rows contain the name of the countries? > What columns and rows contain the name of the *corresponding* elements? [quoted text clipped - 47 lines] > > > > > > Thanks beforehand 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. SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > In the sheet ! i have > [quoted text clipped - 83 lines] > > > > > > > > Thanks beforehand |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.