Hello again, I have a question. In the solution that you gave me is
(BA7<4,BB7<4.25) the "AND" or the "OR"? And more importantly can we make it
the "OR"? It seems to me that both need to be true to start the INDEX,MATCH.
could it be either instead?

"Biff" wrote:

Hi!

=IF(OR(AND(BA7<4,BB7<4.25),AND(BA7=1,BB74.25)),IN DEX.......................)

What if BB7 = 4.25?

Biff

"M.A.Tyler" <Great Lakes State wrote in message
...
Hello,
Here is my function:
=IF(AND(BA7<4,BB7<4.25),INDEX(A235:J235,MATCH(N115 ,A234:J234,0)),"")

The trouble is that it would be possible for BA7to=1, and BB7 to be 4.25.
This could only happen if BA7 were to =1. If this were the case I would
still
like to preform the Index,Match.

Any Ideas?

Thanks in advance!!