Here is my data.
DT NAME QTY
02-May AA 2
02-May AA 2
02-May BB 2
02-May CC 2
06-Aug AA 6
06-Aug BB 6
06-Aug CC 6
07-Aug AA 7
07-Aug BB 7
07-Aug CC 7
09-Aug AA 9
09-Aug BB 9
09-Aug CC 9
10-Aug AA 10
10-Aug BB 10
10-Aug CC 10

I want to lookup latest value of BB which is in this case 10
(I want just lookup value, sum or count is not required)
My arrey formula is =INDEX(LTP,MAX(IF(Code=A55,ROW(Code))))

This data is dynamic, i.e. everyday 8-10 row of data will be added.

Is there a way to avoid the arrey formula in this case?

Regards,
Madiya