Hello,

I'm using this vlookup, however it's returning a blank if the cell it's
referencing is blank. how do I write this formula so the return of a blank
cell is blank?

=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ",
VLOOKUP(A3,contacts!B:I,5,FALSE))

Thanks

You lost us. You just told us the formula is doing exactly what you want
("return of a blank cell is blank"). You'll need to provide a clearer
explanation of your problem. Examples are normally the best way.

Regards,
Fred

"Jim" wrote in message
...
Hello,

I'm using this vlookup, however it's returning a blank if the cell it's
referencing is blank. how do I write this formula so the return of a
blank
cell is blank?

=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ",
VLOOKUP(A3,contacts!B:I,5,FALSE))

Thanks

Maybe...

Use "" instead of " "

=if(iserror(vlookup(...)),"",vlookup(...))


Jim wrote:

Hello,

I'm using this vlookup, however it's returning a blank if the cell it's
referencing is blank. how do I write this formula so the return of a blank
cell is blank?

=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ",
VLOOKUP(A3,contacts!B:I,5,FALSE))

Thanks

--

Dave Peterson

=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ",
VLOOKUP(A3,contacts!B:I,5,FALSE))

Vlookup never result blank when the lookup value is present in the lookup
range. It will result 0 value when the resulting column is not having any
value.

I think you are looking for a formula like the below:-

=IF(ISNA(VLOOKUP(A3,Contacts!B:I,5,FALSE)),"Lookup Value is not Available in
The Lookup Range",VLOOKUP(A3,Contacts!B:I,5,FALSE))

If you want to show the Display message as BLANK when the lookup value is
not present in Lookup range then use the below one:-

=IF(ISNA(VLOOKUP(A3,Contacts!B:I,5,FALSE)),"BLANK" ,VLOOKUP(A3,Contacts!B:I,5,FALSE))

Instead of using ISERROR use ISNA.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Jim" wrote:

Hello,

I'm using this vlookup, however it's returning a blank if the cell it's
referencing is blank. how do I write this formula so the return of a blank
cell is blank?

=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ",
VLOOKUP(A3,contacts!B:I,5,FALSE))

Thanks

Here is the answer I posted on Jan 26 when you asked almost the exact same
question...

=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))

so in this case...

=IF(or(ISna(VLOOKUP(A3,contacts!B:I,5,FALSE)),
VLOOKUP(A3,contacts!B:I,5,FALSE) = ""), "",
VLOOKUP(A3,contacts!B:I,5,FALSE))
--
HTH...

Jim Thomlinson


"Jim" wrote:

Hello,

I'm using this vlookup, however it's returning a blank if the cell it's
referencing is blank. how do I write this formula so the return of a blank
cell is blank?

=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ",
VLOOKUP(A3,contacts!B:I,5,FALSE))

Thanks