Put this in C2:

=IF(B2="","",B2+VLOOKUP(F2,AA$1:AD$2,4,0)+4)

then copy down.

Hope this helps.

Pete