Thread
:
lookup
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
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
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson