Forum Discussion
Excel Formula --> Return column heading dependent on data in rows (& conditions)
Hi there, Kindly looking for some help on the following roadblock I’ve hit: Context: I work for a consulting business. Depending on rules (which I won’t go into), we determine whether a c...
=INDEX($F$5:$J$5,LARGE(IF((F6:J6=1)*(YEAR(E6)>=$F$5:$J$5),COLUMN(A:E)),1))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.