I don't have the exact answer to your question, but maybe reading the link
below helps you on your way

http://office.microsoft.com/en-us/ex...260381033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"awest" wrote in message
...
I am trying to combine information from three different reports from SAP
that
I sent to excel files. I am using the INDEX and MATCH formulas to match
order numbers from each of these reports to get description, time worked,
employee name, part consumed and qty of part consumed for each order. My
problem is that multiple parts can be used for one order but when I do the
INDEX and MATCH formula I can only get a return for one of the three
parts,
for example. Before I move on with combining these reports I wanted to
see
if there is capabilty for excel to "insert a cell" so that multiple
returns
of the formula can be matched to one order. Hope this makes sense. I
appreciate any help!