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.
--

Hi Claus,

Format is general, actual numbers.

The formula you just posted works with the single threshold of 500.
There are two other thresholds, 1500 and 5000.

I am thinking there does not need to be a 'range', like 499 and < 1500 etc.

So I am using =IFERROR(INDEX($E$1:$P$1,MATCH(MAX(IF($E$2:$P$2=50 0,$E$2:$P$2)),$E$2:$P$2,0)),"") pulled across B, C & D.

B for 500, C for 1500 & C for 5000. And this looks like it meet requirements.

Thanks much.

Howard