Adding if error

**geliedee** · 10-21-2014, 01:51 PM

Hi guys,

How to add if error in this formula?

Please Login or Register  to view this content.

thanks!

**sktneer** · 10-21-2014, 02:03 PM

This formula will produce error if the Vlookup return #N/A, so you may use it like this.....

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

The first one will return "No" while the second one will return blank.

**samba_ravi** · 10-21-2014, 02:04 PM

=IFERROR(D2=VLOOKUP(A2,'7.GD Add Bank Details'!A:D,4,0),"")
Try this

**sktneer** · 10-21-2014, 02:06 PM

Just forgot to tell you that you can change the range reference in the suggested formula as per your original formula.

Re: Adding if error