iserror and isblank formula use both in one formula

  • how to use iserror and isblank function in given formula to check blank and error.


    =IF(LEN(VLOOKUP(A2,Sheet2!A2:C50,2))=0,"",VLOOKUP(A2,Sheet2!A2:C50,2))

  • Re: iserror and isblank formula use both in one formula


    Try this:


    =IFERROR(IF(VLOOKUP(A2,Sheet2!A2:C50,2)="", "", VLOOKUP(A2,Sheet2!A2:C50,2)), "")

    Best Regards,
    Luke M
    =======
    "A little knowledge is a dangerous thing."

  • Re: iserror and isblank formula use both in one formula


    krpatel,


    It would be better to stay in the same thread as you started when dealing with same question. This eliminates confusion and having multiple people answer your same questions.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!