| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching across multiple worksheets
Hello -
I have a master worksheet containing company names only. I have several other worksheets in the same workbook containing company names and associated contacts(people, titles, email address, phone num. etc.) I need to find a formula that will match the companies on the master with matching companies in the workbooks and return the associated contacts and their contact info (all contained in seperate columns) Please help!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching across multiple worksheets
Have you looked at VLOOKUP in Help?
"Pete" wrote in message ... Hello - I have a master worksheet containing company names only. I have several other worksheets in the same workbook containing company names and associated contacts(people, titles, email address, phone num. etc.) I need to find a formula that will match the companies on the master with matching companies in the workbooks and return the associated contacts and their contact info (all contained in seperate columns) Please help!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching across multiple worksheets
Excel 2003
Difficulty level: High Maintainability: Well nigh Impossible http://www.freefilehosting.net/download/3bkm6 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching Cells on different worksheets | Excel Discussion (Misc queries) | |||
| matching 2 worksheets together | Excel Discussion (Misc queries) | |||
| Finding matching fields accross multiple worksheets | Excel Discussion (Misc queries) | |||
| return multiple records matching multiple criteria | Excel Worksheet Functions | |||
| MATCHing through multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
