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

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

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

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

--
Biff
Microsoft Excel MVP


"Jim" wrote in message
...
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

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

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


--
HTH...

Jim Thomlinson


"Jim" wrote:

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

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

=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"" ,IF(VLOOKUP(F2,Master!A:D,2,0)="","",VLOOKUP(F2,Ma ster!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.
--
David Biddulph


"Jim" wrote in message
...
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