View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete Pete is offline
external usenet poster
 
Posts: 193
Default 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!!!