Okay, nevermind that. I've figured it out. I used
=IF(B24="",0,(VLOOKUP(C24,$A$5:$E$13,(D24-109),TRUE)*E24*$E$16))

Now, I do have an additional problem. I must repeat this question except
using HLOOKUP instead of VLOOKUP. I am open to suggestions on that now.