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))
We will be implementing some important changes during 25th and 26th May 2024 which may result in an outage period of the website. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
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!