IF greater with a Vlookup, no #N/As

I'm currently using the formula belowto determine if my value in A2 (my projection) is less than the amount of my Current Expense.

Please Login or Register  to view this content.

If the expense is greater, I want to put the expense, if my projection is greater, I want to put nothing. The formula works, but if the vlookup results in an #N/A, the #N/A is deposited. How can I alter my formula to do what I want but without #N/A's appearing?

You can wrap IFERROR around it:

=IFERROR(IF(VLOOKUP(A2,'Current Expense'!A:E,5,FALSE)>J2,VLOOKUP(A2,'Current Expense'!A:E,5,FALSE)-J2,""),"")

Hope this helps.

Pete

Pete, thanks so much. I had tried to use IFERROR, but got the syntax wrong. Thanks for straightening me out.