"Teri" wrote...
I copied this right into my spreadsheet and got an error message.
Is there a ( missing somewhere?

"Harlan Grove" wrote:
....
=IF(C2="","",VLOOKUP(E2,$J$2:$L$6,3)+ISNUMBER(C2 ),0.5,0))

No, there's a missing IF call. Make that

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