We are not inclined to do your homework for you. A couple of things I would look at:

1) All of your references are relative references. I would suggest a little research on using relative and absolute references in formulas and adapting your formulas accordingly

2) I notice that all of your "conditionals" in your IF functions are "exactly equal to", which is not very likely to ever occur. I think you need to adjust your lookup table and your lookup logic to better match the problem statement.