# Maximum/Minimum value from range and then from cell color

1. ## Maximum/Minimum value from range and then from cell color

 3.6 Formula Range 4.02 3.97 3.93 3.89 3.8 3.68 3.3 3.7 3.69 3.79 3.72 3.72 3.74 3.61 3.58 3.5 3.6 3.5 3.55 3.57

I want to take a value in Cell "A2" that is less then or equal to the value in cell "A2" from range of "E2:W2"
The problem is, there are 6 values which are that are less then or equal to 3.6
I only want to take the value which comes first by using a formula.  Register To Reply

2. ## Re: Maximum/Minimum value from range and then from cell color

welcome to the forum
=IFERROR(INDEX(E2:W2,MATCH(TRUE,INDEX(E2:W2<=A2,0),0)),"")
try this  Register To Reply

3. ## Re: Maximum/Minimum value from range and then from cell color

Or perhaps this...
=MIN(A2,INDEX(\$E\$2:\$X\$2,MATCH(SMALL(\$E\$2:\$X\$2,1),\$E\$2:\$X\$2,0)))  Register To Reply

4. ## Re: Maximum/Minimum value from range and then from cell color Originally Posted by nflsales welcome to the forum
=IFERROR(INDEX(E2:W2,MATCH(TRUE,INDEX(E2:W2<=A2,0),0)),"")
try this
Nflsales thanxxx

This worked like a charm can you please also explain me the syntax of this formula how it worked  Register To Reply

5. ## Re: Maximum/Minimum value from range and then from cell color Originally Posted by FDibbins Or perhaps this...
=MIN(A2,INDEX(\$E\$2:\$X\$2,MATCH(SMALL(\$E\$2:\$X\$2,1),\$E\$2:\$X\$2,0)))
Thank you for trying but it did not worked. it is only taking minimum value  Register To Reply