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

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

Matching across multiple worksheets
 

Excel 2003
Difficulty level: High
Maintainability: Well nigh Impossible
http://www.freefilehosting.net/download/3bkm6