Lookup farthest right value in a row

[Rachel999]

Hello,
I need to lookup a text value in an entire row. The formula should find the farthest right position, and give me back the value at the top of the column it was found in. Attached an example.

After searching the forum I am still struggling to find an answer to my needs.

Any ideas?

Regards,
Rachel

 

[NARAYANK991]

Hi Rachel ,

See your file.

Narayan

 

[Rachel999]

Thanks Narayan, I think you resolved my problem!
Have a nice day
Rachel