Hi. I am getting the #N/A error with this formula and I've tried adding IFERROR to it to blank it, and also IFISNA but I cannot get the formula right. Would someone please show me how to revise this formula to show a blank instead of #N/A? Thanks!
=IF(OR(AS7="",AR7=0),"",IF(AQ8="NEXT",((VLOOKUP(N7,KEEP!$D$5:$E$92,2,FALSE)&O7&"000-11400-0000"))))