Thread: lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pat Pat is offline
external usenet poster
 
Posts: 210
Default 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