Nested IF with Vlookup isn't calculating correctly

[heresteve2]

For the life of me I cannot figure out what is going on with this workbook.

I have the same exact formula for all the cells in column F but with one specific instance it is calculating $18 under what it should. I have attached the workbook and I am looking at cell F47 on the Renewal Chart Tab as an example.
The problem happens to all rows with the Type (Column B) set as "2B10".

I've looked at formating but it all looks correct. Please let me know if you can help or have questions because this is driving me nuts!
Thanks in Advance!

[Jonmo1]

Add the FALSE as the 4th argument in ALL the vlookups in your formula.

[heresteve2]

That seems to have worked. I don't get why it was only happening on that one Type though and where the 18 came from?

Thanks!

[Jonmo1]

With the FALSE omitted, it is assumed to be TRUE

When TRUE is used as the 4th argument in vlookup, it does a 'closest' match type of lookup.
And this requires the data in the range to be sorted in Ascending order, which is not the case in your data.

When TRUE is used on UNsorted data, all kinds of very wierd things can happen. Including returning the value you actually expected, though it's purely coincidental.