Finding Date of Max Value

[tennisdude23]

Hi,

I have a project I am working on where I am trying to find a max value in a row and then insert that max value into its own column and then next to that column create a new one that returns the date that the value occurred on. Any suggestions or functions for how I could find that date? I have tried hlookup but I get an N/A or Name? error every time.

Thanks again,

JR

 

[dUBBINS]

I assume your problem is that, most likely, your dates are above the numbers; and that would be backwards for an HLOOKUP().

Let's say your max number it finds is in D1.
=MAX(A2:Z2)

If your dates in Row 1, and your numbers in Row 2, try this in Cell D2
=INDEX(A1:Z1,0,MATCH(D1,A2:Z2,0))