Hi everyone,
I have a sheet with 11 tabs (10 monthly tabs that are identical in format and a summary tab). I have a max formula to find the largest number in column B, but I am trying to index match this so i can get the name from column A that matches this largest number.
I tried this with the only return being a #value!
{=INDEX(P4Y2014!A:A,P13Y2014!A:A,MATCH(B3,MAX(P4Y2014!B:B,P13Y2014!B:B),0))}
Any thoughts?
Mark
Bookmarks