Combining ISBLANK and IFNA in a simple formula

[Usuallymoderatelyconfused]

I know this should be simple but either it is not possible or my brain just cannot put it together correctly and I know it shouldn't be difficult.


Both of these formulas work but are each are missing either one or the other options I need, I need the ISBLANK to keep blank column for a picky boss and the "not found" when A21 is not in Table1

=IFNA(VLOOKUP(A21,Table1,2,FALSE),"Not found" (this gives me the "not found" that i need but not the blank column)
=IF(ISBLANK(A21),"",VLOOKUP(A21,Table1,2,FALSE)) (this gives me the blank column but now I have no "not found" just #NA)


Can they be combined?

 

[NateSC]

Just drop the IFNA formula into the second part of the second formula.
(That sounded less confusing in my head... see below)

=IF(ISBLANK(A21),"",IFNA(VLOOKUP(A21,Table1,2,FALSE),"Not found"))

I didn't test it, but this should work.

 

[Fluff]

Hi & welcome to MrExcel.
How about

IF(ISBLANK(A21),"",ifna(VLOOKUP(A21,Table1,2,FALSE),"Not found"))

 

[Wookiee]

This worked for me (I combined your formulas into one overarching one)

=IF(ISBLANK(A1),"",IFNA(VLOOKUP(A1,Table1,2,FALSE),"Not found"))

 

[Usuallymoderatelyconfused]

Thank you all, I kept trying to put the IFNA into the beginning and not into the second search.

Thanks again!!

 

[Fluff]

Glad we could help & thanks for the feedback.