Multiple IF Statement

  • Thread starter Thread starter David Critelli
  • Start date Start date
D

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
 
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))
Click to expand...

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


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

Dave
 
Back
Top