I believe I have found part of the issue ... too many If statements??

Any thoughts? If you can convert the formula to a lookup that would be greatly appreciated. I am a visual learner so seeing it would help.