Matching and returning values to a master sheet in Excel 2007
 

Hi -

I have a workbook containing several worksheets which have company names and
contact data for several different contacts associated with each company. I
also have a master worksheet which contains company names only. I want to
find a formula for matching the company name on the master worksheet with
matching company names on the other worksheets and return the corresponding
contacts for those companies to the matching company on the master. I would
prefer a formula that matches the entire list of master companies rather than
one at a time.

Thanks