Here's what I am trying to do. I have the following combination of
information in two different worksheets of a workbook: (Part Number) +
(Machine ID) + (Week - contained in a different cell and not added to the
combination). The (Part Number) + (Machine ID) will be the same from week to
week, but the last piece of information (Week) obviously changes each week.
I wanted to try and do a VLOOKUP on the identifier (combination above) and
return back order and delivery data (listed in specific columns). The
formula is working up until the point where the (Part Number) + (Machine ID)
is contained in multiple weeks and then, of course, the formula does not even
see that there is another line item below the first one it sees.
Unfortunately there may be multiple combinations in the data set which
contain the first two piece of information and only the week varies.

Is there a way to perform a VLOOKUP which will take the (Part Number) +
(Machine ID) value, then look for the week and then return the values
requested? There will never be the same combination of data in a given week,
meaning the (Part Number) + (Machine ID) +(Week) is a unique identifier.
However, because of the way the data is set up, I cannot combine all three
values into one field.

Is what I am trying to do even possible?
Any help / suggestions would be greatly appreciated!!

Thanks,
Liz