Forum Discussion
Formula help return header from max value
Hi I would like to return the header from the highest value. In the example below with the right formula in sheet 1, cell b4 this would return Cherries.
I keep getting a N/A result in mine. Unfortunately it has to be between to sheets. I'm just not sure what the problem is.
cheeseontoast101 Then you need to show a bit more on how you use the formula in real life. With regard to having to use different sheets, that's fine. But, I'd still recommend that you use Named Ranges.