Matching and returning values to a master sheet in Excel 2007

P

Pete

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Matching across multiple worksheets 2
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
VLOOKUP FOR COMPANY AND EMPLOYEE 1
Automatic Emails sent to my Contact Groups by Microsoft 1
Return Text based upon text matching 6
How to update data from linked worksheet back to a master worksheet? 0
How to update a value from a linked worksheet back to the master worksheet? 0
Extracting a cell value 2

Top