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
---------------
Jacob Skaria


"H" wrote:

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