how to use Index right to left (See data and return the highest value)

[inspectengr]

Following is the screen shot. We are suppose to get following values
- the first value from right side
- year of first value
- 2nd value
- year of 2nd value

In order to get the year of 1st value we employed INDEX MATCH LOOKUP

=INDEX($J$4:$X$4,MATCH((LOOKUP(2,1/(J14:X14<>""),J14:X14)),J14:X14,0))

But since data values are same in 14 row, when data goes to return the corresponding year, it picks 2005 the year instead of 2018. Thus leading to errors in calculation

 

[Fluff]

Hi & welcome to MrExcel.
Try it like

=LOOKUP(2,1/(J14:X14<>""),$J$4:$X$4)