I am trying to find a next match based on given formula and need help
In my table
A B C
0 0 0
=IF(D5=100,"-",IFERROR(INDEX('YTD - 09'!B$2:V$2,MATCH(D5,'YTD - 09'!B5:V5,0)),"-"))
As of now if the results are
A A A
However, I want the results to be
A B C
Bookmarks