Thread: lookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default lookup

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



Pat wrote:

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


--

Dave Peterson