IFERROR VLOOKUP

[Tgpitch16]

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")

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Legacy 143009]

How about:

=IF(D18<>"",IFERROR(VLOOKUP(D18,Table2[#All],2,FALSE),"No matches message"),"Blank message")

 

[Tgpitch16]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Done

 

[Fluff]

Thanks for that.
How about

=let(v,VLOOKUP(D18,Table2[#All],2,FALSE),if(d18="","Blank",IF(ISNA(v),"No match",v)))

 

[Tgpitch16]

How about:

=IF(D18<>"",IFERROR(VLOOKUP(D18,Table2[#All],2,FALSE),"No matches message"),"Blank message")

Perfect, thank you

 

[Legacy 143009]

Glad it did work! Thanks for the feedback