lookup

  • Thread starter Thread starter Pat
  • Start date Start date
P

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
 
Hi
=if(B4="","",LOOKUP(B4,{0,1,2,3,4,5},{0,7,9,11,13,15}))

if this helps please click yes, thanks
 
=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
Click to expand...
 
Back
Top