Using Vlookup and IF statements to check for blank cells
 

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

=VLOOKUP(B4,'Price List'!$A$3:$B$13,2,FALSE)
--
Thanks from Salt Spring

Using Vlookup and IF statements to check for blank cells
 

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


Koomba wrote:

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

=VLOOKUP(B4,'Price List'!$A$3:$B$13,2,FALSE)
--
Thanks from Salt Spring

--

Dave Peterson

Using Vlookup and IF statements to check for blank cells
 

Dave: that was SIMPLY great. Thanks
--
Thanks from Salt Spring


"Dave Peterson" wrote:

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


Koomba wrote:

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

=VLOOKUP(B4,'Price List'!$A$3:$B$13,2,FALSE)
--
Thanks from Salt Spring

--

Dave Peterson

Using Vlookup and IF statements to check for blank cells
 

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),"")


--
Thanks,
Shane Devenshire


"Koomba" wrote:

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

=VLOOKUP(B4,'Price List'!$A$3:$B$13,2,FALSE)
--
Thanks from Salt Spring

Using Vlookup and IF statements to check for blank cells
 

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,


"Koomba" wrote:

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

=VLOOKUP(B4,'Price List'!$A$3:$B$13,2,FALSE)
--
Thanks from Salt Spring