lookup

[Pat]

I am using a lookup =LOOKUP(B4,{0,1,2,3,4,5},{0,7,9,11,13,15}) but when B4 is
blank it puts in a 0 in my cell, I need it to stay blank if their is no
value in B4

 

[Eduardo]

Hi
=if(B4="","",LOOKUP(B4,{0,1,2,3,4,5},{0,7,9,11,13,15}))

if this helps please click yes, thanks

 

[Dave Peterson]

=if(b4="","",lookup(....)))

I am using a lookup =LOOKUP(B4,{0,1,2,3,4,5},{0,7,9,11,13,15}) but when B4 is
blank it puts in a 0 in my cell, I need it to stay blank if their is no
value in B4

 

[Sean Timmons]

=IF(B4="","",LOOKUP(B4,{0,1,2,3,4,5},{0,7,9,11,13,15}))

 

[Teethless mama]

=IF(B4="","",B4*2+5*(B4>0))