Multiple IF Statement

[David Critelli]

I have created this IF Statement

=IF(ISBLANK(E7),"",VLOOKUP(A7,'Wk1 Holders'!AE:AH,4,0))

which basically looks into cell to see if it is blank and returns a blank cell but if it isn't then it looks up on another tab for the value in A7. This is successful but how can I make the cell still appear blank if the VLOOKUP returns "#N/A"?

Thanks

 

[Claus Busch]

Hi David,

Am Wed, 7 May 2014 04:42:07 -0700 (PDT) schrieb David Critelli:

=IF(ISBLANK(E7),"",VLOOKUP(A7,'Wk1 Holders'!AE:AH,4,0))

try:
=IFERROR(IF(ISBLANK(E7),"",VLOOKUP(A7,'Wk1 Holders'!AE:AH,4,0)),"")


Regards
Claus B.

 

[David Critelli]

Many thanks Claus. That looks like it has solved my problem. I really appreciate it.

Dave