How to search and return a specific value in a row (Google sheets/Excel)

Question

Working on a scheduling file. What would be the easiest way to find what was the last day someone worked in this sheet.

"C" means someone has worked that day and dates are in row 2,

Basically searching for last value "C" in row 16 and returning date from row 2.

I am very new google sheets

Thanks

Answer 1

In Excel

=XLOOKUP("C",16:16,2:2,,0,-1)

Search for "C" in row 16, exact match, last to first, return from row 2

_{Requires Excel365}