Hello,
Welcome to the forums!
You are missing a couple parenthesis, which could cause your problems:
=IFERROR(VLOOKUP(RIGHT(M3,7),notes!A:A,1,FALSE),"Failure to process correctly ",IFERROR(VLOOKUP(RIGHT(N3,7),notes!A:A,1,FALSE),"Failure to process correctly"))
EDIT: Actually, you also have too many arguments. You say If the vlookup returns an error, to return "Failure to process correctly", but then you have another iferror and another vlookup. What are you trying to make happen, because it does have too many arguments.
=IFERROR(VLOOKUP(RIGHT(M3,7),notes!A:A,1,FALSE),IFERROR(VLOOKUP(RIGHT(N3,7),notes!A:A,1,FALSE),"Failure to process correctly"))
=IF(AND(M3="",N3=""),"Failure to process correctly",IFERROR(VLOOKUP(RIGHT(M3,7),notes!A:A,1,FALSE),IFERROR(VLOOKUP(RIGHT(N3,7),notes!A:A,1,FALSE),"Failure to process correctly")))
Thank you so much.. it works good except for when there's nothing in M5 or N5. Can anything be done to show"Failure to process correctly" when this happens?
Do you mean (1) nothing in M5 as well as in N5, or (2) nothing in either M5 or N5?
That is correct Aladin.
Sometimes there may not be nothing in M5 ( which means its blank) and or N5 could be blank or it could have the information in it.