That is quite different than the formula I had suggested for your initial question.

I'm not sure I know what you are trying to do with that formula...

You've got arrays of different sizes
You've got conditions >=J9 and <=J9 will both be true when the value in the range actually equals J9...
And your value if true is not much different than the value if false (which the range overlaps your condition check value (E18).

Please explain in words what you are actually wanting to accomplish.