Problem with Vlookup formula

[Mldeuser]

Hello

I am using a vlook up formula to pull information from a data dump file (=(IF(ISNA(VLOOKUP(A4&B4,Sheet3!A:M,10,FALSE)),"",VLOOKUP(A4&B4,Sheet3!A:M,10,FALSE)))+1). The problem I have is there may be more than one row that fits, is there a way when there is more than one row that it can look at column M (date column) and use the row with the most current date.

For example I have a situation where there are six rows that fit the criteria so the formula brings back the information from the first row it finds, In this case the row I would like it to look at column M and bring back the information in the row with the most current date.

Is this possible.

Thank you
Mark

 

[Aladin Akyurek]

If the dates are in chronological order...

=LOOKUP(9.99999999999999E+307,SEARCH(A4&B4,Sheet3!A:A),Sheet3!M:M)

Why is that +1?

 

[Mldeuser]

The plus 1 is to add one day to the date it brings back.

 

[Aladin Akyurek]

The plus 1 is to add one day to the date it brings back.

Thus:

=LOOKUP(9.99999999999999E+307,SEARCH(A4&B4,Sheet3!A:A),Sheet3!M:M)+1

 

[Mldeuser]

It is working perfectly thank you

 

[Aladin Akyurek]

It is working perfectly thank you

You are welcome.