I copied this right into my spreadsheet and got an error message. Is there a
( missing somewhere?
"Harlan Grove" wrote:
Teri wrote...
I still get #N/A as a result.
"Peo Sjoblom" wrote:
....
=(C2<"")*(VLOOKUP(E2,$J$2:$L$6,3,0)+IF(ISNUMBER (C2),0.5,0))
....
"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 ))
....
________J_______ ________K_______ __L__
GP Greater Than But Less Than... Points
or Equal To...
-100% 0% 0.0
0% 21% 0.5
21% 31% 1.0
31% 40% 1.5
40% 101% 2.0
Peo may have erred by using a 4th argument to VLOOKUP. Given the table
above, it's unlikely you want exact matching. Try
=IF(C2="","",VLOOKUP(E2,$J$2:$L$6,3)+ISNUMBER(C2), 0.5,0))
|