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))
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)), "")
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.
Don’t have an account yet? Register yourself now and be a part of our community!