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!