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


    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.

    :!:Forum Rules