Returning value of a column header from last instance of a cell value

[iksotof]

Hi

I have a sheet with column headers of dates (left most historic to right most recent) against a column for names. In each row name, I denote under the corresponding date column when the client fulfilled an appointment with the simple text of "review". Over time there are mutliple reviews. I need to establish in one column adjacent to the each client row when the last "review" took place. I have attached an example sheet, using the first entry, the most recent review was under Jun 23 column (yellow), the second row client is in Jul 23 (dark blue), third row is Aug 23 (light blue). My ideal solution would be in the column headed "Last Review" to pull through the respective last review date for that eow client, as in the attached examnple.

Any help would be appreciated.


Thank you

[HansV]

In B2:

=LOOKUP("z",$C2:$T2,$C$1:$T$1)

Fill down.

[hamster]

try Power Query

[snb]

=EDATE($C$1;MAX(($C2:$T2="Review")*COLUMN($A:$R))-1)

[iksotof]

Thank you both, these help and I certainly can use going forwards, I need a bit more work on Power Queries :)

Apologies hwever, I didn't define the problem sufficiently, there are other entries in the sheet, I have uploaded a revised example. As you can see I have
"other" entries along the way too, it is the last occurence of "Review" with its corresponding date I am looking for please.

Again your help is most appreciated.

Thank you
Darren

[HansV]

You can use

=LOOKUP(2,1/($C2:$T2="Review"),$C$1:$T$1)

[hamster]

just for fun again with Power Query