One way, if I understand you correctly (array entered: CTRL-SHIFT-ENTER
or CMD-RETURN):

=IF(S190,MAX(($B$8:$B$14000=B19)*($T$8:$T$14000)) )

In article ,
Eddy Stan wrote:

I just put this formula to find maximum value

=if(and(s190,b8..b14000=b19),max(t8..t14000),0)

I want to check if value in s19 0 then
find the range equal to value in b19 in b8..b14000 then
find parallel range in t8..t14000 then
find maximum value in that range

That is value in b19 = 2, which there in b19 to b27 (b19 = 2, b20 =2, ....)
Now there is value in t19 is 25, t20 is 45, t21 is 5, t22 is 100... t27 is 75
maximum value between t19 to t27 is at t22 100, which is the value I require.

I want to copy the formula you give thro u8 ... u 14000
so that I get max value in "U" range.

my advance thanks to you..