Forum Discussion
Find Highest Value In A Row, Return the column header - across sheets
Hi I'm trying to return the header that matches the highest value in a row but I'm having some trouble with my formula. =INDEX(Sheet2!A1:F1,0,MATCH(MAX(Sheet2!A10:F10,Sheet2!A13:F13),Sheet2!A...
If you're on the Beta channel, use VSTACK to consolidate the data across sheets and then use the formula of your choice to pull the column header.