=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"",VLOOKUP(F2,Mast

J

Jim

Hello Excel guru's,

How do I change this formula:
=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"",VLOOKUP(F2,Master!A:D,2,0))

So that it will return a blank field instead of a '0' if the cell it's
referencing is blank?

Thanks
 
J

Jim Thomlinson

=IF(or(ISNA(VLOOKUP(F2,Content_Insert!A:A,1,0)),
VLOOKUP(F2,Master!A:D,2,0)=""),"",VLOOKUP(F2,Master!A:D,2,0))
 
D

David Biddulph

=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"",IF(VLOOKUP(F2,Master!A:D,2,0)="","",VLOOKUP(F2,Master!A:D,2,0)))

But you may want to test for an error in VLOOKUP(F2,Master!A:D,2,0) too.
You've tested for an error in a different VLOOKUP.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top