The IFVLOOKUP Function

I recommend following your calculation through each step using the Evaluate formula tool (https://support.office.com/en-us/art...6-a70aa409b8a7 ). You should see:

1) lookup value is 1000
2) result of lookup is 2
3) Evaluate boolean expressions from left to right
3a) 2=1 is FALSE
3b) FALSE>=2 is TRUE, because a boolean value is always "larger" than a number.
3c) I note that this will always be the result, whether 3a returns TRUE or FALSE, so the result of this logical test will always be TRUE (unless the lookup returns an error).
4) Return value_if_true argument and ignore value_if_false argument.

It is not clear to me what your logical test should be testing for, but it appears to me that you have not correctly translated your intended logic into an appropriate logical expression. Correct the logical expression, and the function should work correctly.