Hi

I have the following Excel formula which is trying to return the oldest date from a multiple criteria:

{=MIN(IF(A:A=W1,IF(Q:Q=X5,O:O)))}

Column A contains the customer number which is matched here by cell W1 (Col A also contains multiple incidences of the same customer number so can appear many times in the list).

Column Q contains product codes

Cell X5 contains a specific product code however I wish this to match against 8 other codes in a list. Unfortunately if you specify a range it isn't returning the correct data - i.e. {=MIN(IF(A:A=W1,IF(Q:Q=X1:X9,O:O)))}

Column O contains the dates of which I wish to report the oldest based on a match being made on the product code for that customer number.

Any help or advice would be much appreciated.

Many thanks

Stephen