This will still return 0 in case that there is a blank cell.

I would go with two VLOOKUP function as gtdean11 assumed in a frist place