# Excel Function: Multiple IF conditions, Must return ""

• Dear all,
I am trying to find a IF function with multiple criteria to get the output as "" (Blank).

I want If function to return "", if its vlookup value is "" or #N/A.
Below is the function i am using, but it still throws #N/A for few cells, while it must return ""

Code
1. =IF(OR(VLOOKUP(A1,D:E,2,FALSE)="",ISNA(VLOOKUP(A1,D:E,2,FALSE))),"",VLOOKUP(A1,D:E,2,FALSE))

Please find the attachment.

Please correct my small mistake.

## Files

• Function.xlsx

(9.04 kB, downloaded 56 times, last: )
• Re: Excel Function: Multiple IF conditions, Must return &quot;&quot;

Try this, copied down:

Code
1. =IFERROR(IF(OR(VLOOKUP(A1,D:E,2,FALSE)="",ISNA(VLOOKUP(A1,D:E,2,FALSE))),"",VLOOKUP(A1,D:E,2,FALSE)),"")

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

• Re: Excel Function: Multiple IF conditions, Must return &quot;&quot;

Works great....Thanks a lot..:)