I'm trying to accomplish three things within my formula and it isn't working. What am I doing wrong? Any help would be greatly appreciated.
1) Display a message when D18 is blank
2) Return VLOOKUP value
3) Return a different message when VLOOKUP doesn't exactly match a value in my table
=IF(LEN(D18)>1,VLOOKUP(D18,Table2[#All],2,FALSE),"Blank message"),IFERROR(VLOOKUP(D18,Table2[#All],2,FALSE),"No matches message")
1) Display a message when D18 is blank
2) Return VLOOKUP value
3) Return a different message when VLOOKUP doesn't exactly match a value in my table
=IF(LEN(D18)>1,VLOOKUP(D18,Table2[#All],2,FALSE),"Blank message"),IFERROR(VLOOKUP(D18,Table2[#All],2,FALSE),"No matches message")