ExcelBanter - lookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - lookup (https://www.excelbanter.com/excel-discussion-misc-queries/241199-lookup.html)

Pat

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

Eduardo

lookup

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

if this helps please click yes, thanks

"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

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

Sean Timmons

lookup

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

"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

Teethless mama

lookup

=IF(B4="","",B4*2+5*(B40))

"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

All times are GMT +1. The time now is 03:15 AM.