Using Vlookup and IF statements to check for blank cells

K

Koomba

I neglected to include my formula in the 1st message. Sorry. Here it is:

=VLOOKUP(B4,'Price List'!$A$3:$B$13,2,FALSE)
 
S

ShaneDevenshire

Hi,

Since you didn't include the first message I'm not sure this will help:

=IF(B4,VLOOKUP(B4,'Price List'!$A$3:$B$13,2,0),"")

Note - if you name the range in the sheet called Price List, for example PL,
then your formula no longer needs a sheet reference, and since range names
are absolute by default you don't need the $ signs. So your formula can
simplify to:

=IF(B4,VLOOKUP(B4,PL,2,0),"")
 
F

franciz

another basic alternative would be

=IF(ISNA(VLOOKUP(B4,'Price List'!$A$3:$B$13,2,FALSE)),"",VLOOKUP(B4,'Price
List'!$A$3:$B$13,2,FALSE))

you can have not found by replacing "" with "not found" in the formula.

regards,
 

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

Similar Threads

Same forumula returns both 0 & N/A 2
Dealing with the error: unable to filter on excel hc home school 0
Hlookup & Vlookup 2
VLOOKUP - Not returning the proper number (Caro) 1
Vlookup to return 0 instead of NA 1
Can I add a formula or function to Vlookup? 1
VLOOKUP & Data Validation 0
Searching the formula (not the value) for a text string 1

Top