Try following formula :

=IF(AND(D25<110,F37=86.49,D25130,F37=102),VLOOKUP (D25,B28:C50,2,TRUE))

Regards
Jed.


"Pank" wrote in message
...
I have the following dilemma.

I have a Vlookup, which tests for values between 110 and 131 and allocates
an appropriate bonus that works fine. If the values are less than 110 and
greater then 130 the resultant cell displays #N/A as expected.

However I have now been advised that if I have a value that is less than
or
equal to 110 I need to allocate a bonus of 86.49 and if it is greater than
or
equal to 131 I need to allocate a bonus of 102.00. Any value between 110
and
131 should invoke the vlookup to allocate the appropriate bonus.

I was hoping to using an 'if then else' statement to set the low and
high-end bonus prior to the vlookup.

I have keyed the formula in as

=IF(D25<110,F37=86.49,D25130,F37=102.00,VLOOKUP(D 25,B28:C50,2,TRUE))

However, I get a message that says 'the formula you typed contains an
error'. I have tried to go through the help but I keep hitting a brick
wall.

Any help would be appreciated.