Thread
:
Lookup ?
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
H
external usenet poster
Posts: 57
Lookup ?
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
Reply With Quote
H
View Public Profile
Find all posts by H