Hi,
I would like to know if it is possible to combine the VLOOKUP and MAX/MIN functions into one formula.
If you see the attached spreadsheet it will make more sense to what I am trying to accomplish. I want the maximum value from my data to be displayed and this is simple with a =MAX(B2:B11) formula and this would display the value 79.3 but this result on its own is meaningless! I need the name of the destination that corresponds to the numerical data to be displayed along with it. After some researching I understand that a VLOOKUP function can provide an output depending on what is inputted but I want the maximum value to be the numerical output with its corresponding text data.
Bookmarks