One way

=(C2<"")*(VLOOKUP(E2,$J$2:$L$6,3,0)+IF(ISNUMBER(C 2),0.5,0))


Regards,

Peo Sjoblom

"Teri" wrote:

I have to calculate a value based on a VLOOKUP, but one of the cells (outside
the VLOOKUP table) may be blank. If that cell is blank, I want zero for an
answer. My current formula is:
=(VLOOKUP(E2,$J$2:$L$6,3)+IF(ISNUMBER(C2),0.5,0))

Cell E2 is a percentage
Cell C2 is a quote number

J K
L
GP Greater Than or Equal To€¦ But Less Than€¦ Points
-100% 0% 0.0
0% 21% 0.5
21% 31% 1.0
31% 40% 1.5
40% 101% 2.0