Hi Howard,

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

The formula returns the #NAME? error on the sheet, and the function wizard points to the match function, result = #NAME? (red)

Using Excel 2010 and Array Enter for the formula. The value in L2 is 550.

When I follow the formula through in the formula box, it sure acts like it should work as I parse through the arguments.

check the formats of the numbers in E2:P2.
Or try:

=INDEX(E1:P1,MATCH(MAX(IF(E2:P2<1500,E2:P2)),E2:P2 ,0))
*Array formula


Regards
Claus B.
--
Windows10
Office 2016