Scheuerman1987, this sounds more like a help-me-understand question than a please-solve-my-problem question, so I'm going to ignore your workbook and switch to Socratic questions:

1) Do you know how the IF function works by itself? If you do, give an example of an IF call; if you don't, say so and I'll explain.

2) Do you know how to use the VLOOKUP function by itself? If you do, give an example or explain it in your own words; if not, tell me as much as you DO understand about it and I'll fill in the gaps.

Once we've gone over the two pieces, it should be easy enough to explain how to use them together—if by then you still need us to.