IF and Vlookup formula combined

Hi there,
I have combined two formulas in one cell and it is not working correctly.

The Vlookup portion works and is returning data from my SAP data but my IF formulas isn't.
Basically this formula should return the data from SAP unless, R11 is "Terminated", then it should write "terminated" in the cell.

Please help, thank you!!!

=VLOOKUP(A11,SAP,20,FALSE),IF(OR(R11="terminated","terminated"))

If you want to have the data returned only if they are not terminated, then your logic is backwards. Test for termination first, then if they are not, vlookup the data.

Shouldn't it be
=IF(R11="terminated","terminated",VLOOKUP(A11,SAP,20,FALSE))