That sort of worked
=IF(I3="",0,IF(I3=TABLE!$A$1,VLOOKUP(F3,TABLE!$A$3:$C$5,2),IF(I3=TABLE!$E$1,VLOOKUP(F3,TABLE!$E$3:$G$5,2),IF(I3=TABLE!$I$1,VLOOKUP
(F3,TABLE!$I$3:$K$5,2),IF(I3=TABLE!$M$1,VLOOKUP(F3,TABLE!$M$3:$O$23,2),IF(I3=TABLE!$Q$1,VLOOKUP(J3,TABLE!$Q$3:$S$12,2,)))))))

It applied the Zero to the blank but now only the first IF in my formula works. Close but getting there.

---------- Post added at 01:41 AM ---------- Previous post was at 01:37 AM ----------

Lol I forgot a ( before the IF starting my formula. It works great now. ^^ Thanks a lot Ace_XL