Select the oldest date of based on "P" in another column

Hello!!!

I need some help to solve this problem:

I want the date associate to the first P value... But i can gat it with Vlookup cus to use this function the values of AY colum must be organized ascendenting... And even if i organize, we obtain the most recent date and no the oldest.

Please someone, take a look and save me

Try:

=INDEX(AZ2:AZ100,MATCH(TRUE,INDEX(AY2:AY100="P",0),0))

adjust ranges to suit.

1. VLOOKUPs do not necessarily need to be sorted in accending order. If you add a fourth argument of FALSE, it will continue to look until it finds an exact match (i.e. =VLOOKUP(A1, $B$1:$C$50,2, FALSE) )

2. I'd use INDEX, MATCH and MIN for this issue
=INDEX($AY$2:$AY$1000, MATCH(MIN($AZ$2:$AZ$1000),$AZ$2:$AZ$1000,0))
Does that work for you?

EDIT: As per NBVC, I forgot to take into account "P" and was looking for first date as in minimum and not in order.

=INDEX($AZ$2:$AZ$1000, MATCH("P",$AY$2:$AY$1000,0))

That formula won't find the first P date.

Try either my formula or ChemistB's better last formula:

=INDEX($AZ$2:$AZ$1000, MATCH("P",$AY$2:$AY$1000,0))

you may need to change the commas to semi-colons for your regional settings

=INDEX($AZ$2:$AZ$1000; MATCH("P";$AY$2:$AY$1000;0))