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

[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,2,0))

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

Thanks

 

[T. Valko]

What type of data does the formula return, is it text, numeric, could be
either?

 

[Jim Thomlinson]

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

 

[David Biddulph]

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

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