Lookup ?

  • Thread starter Thread starter H
  • Start date Start date
H

H

Hi, I've been using this formula
=LOOKUP(Q7, {0,0.11,0.21,0.31}, {"0-10%","11-20%","21-30%","31%+"})

but am wondering if I can add another component to it by adjusting it so
that if Q7 is blank it leaves it blank?

Is that possible?

Thanks
 
By default the value is considered as 0 So use IF condition as below

=IF(Q7="","",LOOKUP(Q7, {0,0.11,0.21,0.31},
{"0-10%","11-20%","21-30%","31%+"}))

If this post helps click Yes
 
thank you Jacob

Jacob Skaria said:
By default the value is considered as 0 So use IF condition as below

=IF(Q7="","",LOOKUP(Q7, {0,0.11,0.21,0.31},
{"0-10%","11-20%","21-30%","31%+"}))

If this post helps click Yes
Click to expand...
 
Back
Top