Hello,
INDEX($B$1:$L$1,0,LARGE(IF(($A$2:$A$8=D15)*($B$2:$L$8="L"),COLUMN($B$1:$L$1),0),1)-1)
I have this formula which takes me to column number 6. I need to understand how it is reaching to column no 6.
I'm attaching a excel sheet as a reference.
Thank you,
Manish
Bookmarks