Find last cell with data, then get column title

[TAPS_MikeDion]

Hi everybody,
This seems like it will probably be an easy one for those of you who are better than I am with Google Sheets formulas.

I have columns R through AC marked JAN, FEB, MAR and so on for the months of the year, with staff rows starting at 3 with a simple X per staff member who attended a meeting that month. All I'm looking to do in column AD is to show the last month that has an X in the cell per staff member.

P​	Q​	R​	S​	T​	U​	V - AC​	AD​
1	MEETINGS HELD	X​	X​	X​			​
2		JAN​	FEB​	MAR​	APR​	ETC​	LAST MEETING ATTENDED​
3	JOE	X​					JAN​
4	BILL		X​	X​			MAR​
5	TOM	X​	X​				FEB​

In the example above, column AD for rows 3, 4, and 5 should read:

3 - JAN
4 - MAR
5 - FEB

Thank you very much for your help on this!

 

[Fluff]

In that case just enclosed it in IFNA

 

[TAPS_MikeDion]

Got it Fluff.

I just combined your 2 formulas and it work perfectly!

=IFNA(LOOKUP(2,1/(D3:O3="x"),D$2:O$2),"")

 

[smozgur]

Thank you, it works like a charm.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.