inspectengr
New Member
- Joined
- Sep 30, 2021
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
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
- 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