Column A Column B Column AU
Apples text1 22
Apples text2 3
Apples text24 1
Bannanas text11 29

Cell AW2 = "Apples"
Cell AY2 = "1"

I would like a formula in Cell AX2 to return "text24"

what is that formula? thanks

I tried it myself based on numerous examples on this discussion group, but
just couldn't do it, many thanks...

SteveC