INDEX MATCH MIN Formula

Hi,

I have an INDEX MATCH function whereby I am looking up the date of a certain company name. However, I need to look up the oldest date for each company name. I have already tried with an AGGREGATE function combined with INDEX, MATCH and MIN but this also resulted in the same outcome (namely, not the oldest date matched).

Formula tried:

Formula:

Please Login or Register  to view this content.

Formula I have at the moment and only matches the date (not the oldest date):

Formula:

Please Login or Register  to view this content.

In sheet Target I match the company name in Column A with the company name in sheet Results in Column D and I then look up the date given in sheet Results in Column L (Completed date), the formula is in Column B in sheet Target. However, I need this to be the oldest date as possible.


See the attached file.


Any suggestions?


Thanks!

Great thanks a lot it works!