Howdy,
I am trying to obtain the date of occurance of a maximum value. Attached is the workbook I am working on. I tried to color coordinate so it is easier to understand my goal. The cell I am referring to has been marked red in there. If I use the HLOOKUP(MaxVal, TableOfTotals&Dates, Row#OfDates) aka [HLOOKUP(B139,B134:NB135,135)] it gives me an error. The end result I am looking for is to have the Date of that MaxVal occurance to be automatically obtained.
Is this the correct function I should be using or am I going the wrong direction?
Thanks,
The_Intern
EAA.xlsx
Bookmarks