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

Advertisements

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

Advertisements

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

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