Hello



I am working on a spreadsheet, and need to convert a list of suppliers materials on different rows, so they are displayed in columns, if this makes sense

- I have attached a spreadsheet showing the issue.

I need to get the "Overview" sheet to list the materials each supplier supplies in horizontal order, I have done V lookups on the first two sheets, so the material supplied is on the "supplier and codes" tab and the supplier is on the "Codes and Materials" tab.

The reason behind doing this is so that I can send out an email (as a mail merge) and the supplier will recieve one email with a list of materials rather than several emails, one for each material.

Hope someone can help me... it would literally save me DAYS!!!!

Attached Files

Excel Problem.xls (33.5 KB, 15 views)

Hi foodstudent,

Essential, what you want to do is to have a series of lookups for each supplier that works with multiple entries per supplier. The formulae for this are quite complex. To see what's involved, have a look at the worksheets attached to my posts at:
http://lounge.windowssecrets.com/index.php?showtopic=771787
and:
http://www.techsupportforum.com/microsoft-support/microsoft-office-support/375768-excel-formula-issues.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]