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

J

#### Jim

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

F

#### Fred Smith

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

D

#### Dave Peterson

Maybe...

Use "" instead of " "

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

M

#### Ms-Exl-Learner

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

J

#### Jim Thomlinson

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 ,2,0)=""),"",VLOOKUP(F2,Master!A ,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))