Reverse or end value for Index/Match formula

[philobr]

Hi there,
Hoping someone can help, if my question makes sense.

I have a formula (in B4) to look up the first value which appears in a row and give me a date from the matching column (apologies I dont know how to add formula and screenshots)

=IFERROR(INDEX($D$3:$L$3,1,MATCH(A4,D4:L4,0)),"")

A4 has X
Row 4 has X at D4, and that will bring back the value from D3
A B C D E
Mon Tues
X Mon X X

What I need is a similar formula in C4 to bring back the last value so C4 will say Tues.

Any ideas?
Thanks

 

[Marcelo Branco]

Try

	A​	B​	C​	D​	E​	F​
1​
2​
3​	Search​	First​	Last​	Mon​	Tue​	Wed​
4​	X​	Mon​	Wed​	X​		X​

<tbody>
</tbody>

Formula in B4
=INDEX($D$3:$L$3,MATCH(A4,D4:L4,0))

Formula in C4
=LOOKUP(2,1/(D4:L4=A4),$D$3:$L$3)

M.

 

[philobr]

Perfect, thats exactly what I was looking for Marcelo, thanks so much.

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.