Hi Howard,

Am Thu, 29 Sep 2016 00:32:29 -0700 (PDT) schrieb L. Howard:

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.

I don't know what you want to do.
Can you send me an example workbook with the expected output?


Regards
Claus B.
--
Windows10
Office 2016