Hey,

I have a list which lists failures of certain parts ( column G,PN in
Failure sheet) inculding the machine (column B,SN .. Serial Number in
Failure)
and Install Date (Column D in Failure) some other dates.

I also have a sheet "Built list" that includes all built Date for those
SN .. Serial Numbers..but we dont care about that. I have no problem
matching those.

The main sheet (called Query1) includes column A: parts (PN) and coulmn
B:Serial Numbers (SN) and Install Date (and other dates), mentioned
above.

I want excel to give me the install date from the Failure-sheet when
the PN *and* SN from the Query1 sheet match the PN and SN in the
Failure-sheet.

For example:

I assign the Install date to a Serial number by
=INDEX(Failure!D:D,MATCH(Query1!$B2,Failure!B:B,0) )
But this ignores the PN and gives me a wrong date.
I don't know how to match both.

I would be very thankful for any help - I hope this was
understandable..
I added the sheet,so you can play with it :)


+-------------------------------------------------------------------+
|Filename: Example.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4604 |
+-------------------------------------------------------------------+

--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=531092