Hi Howard,

Am Wed, 28 Sep 2016 11:13:24 -0700 (PDT) schrieb L. Howard:

Trying to return the header of the cell in the range E2:P2 that has a value greater than 499 and less than 1500.

Formulas, as is, returns header from P column while value of 550 is in L2.

=INDEX($E$1:$P$1,MAX(E2:P2499,E2:P2<1500,COLUMN(E 2:P2)-COLUMN($E$1))+1)

if your Excel version is 2007 or newer:

=INDEX(E1:P1,,MATCH(MAXIFS(E2:P2,E2:P2,"499",E2:P 2,"<1500"),E2:P2,0))


Regards
Claus B.
--
Windows10
Office 2016