VLOOKUP with multiple criteria

[TheinterestedOne]

Hi everyone.
imagine you have a database of orders and you use vlookup to fetch the order that has the hightest overdue(comparing from the today’s date)
I use the basic formulas to retrieve the answer BUT I can’t get my head around when two orders have the the same value.
I want to fetch the order which satisfies the criteria of “which came in first”

eg
Order A - 10 days late (order arrived on 12/02)
Order B - 10 days late (order arrived on 09/02)

in this case, when I would vlookup for the first order that I have to work on, it would analyse the days left and the date of reception and give me back Order B.
and the second priority would be OrderA, because it came in after orderB.

Can some one help me transform the ideia into excel ?

thank you in advance
Best regards from Portugal

 

[LazyBug]

Hello!
If Row 1 is Headers, column A contain dates, and B - orders, and F3 is Order to find:
'=INDEX($A$2:$D$10,SMALL(IF($F$3=$B$2:$B$10,ROW($B$2:$B$10)-1),ROW(A1)),1)