Nested If Alternative?

Hi guys,

I've been racking my brain over this all afternoon. I have a large data set and don't see an alternative to using nested if statements. I figure there must be a way and I'm missing something. My problem is like me wanting to use vlookup with range as my lookup value. Any help is appreciated. I have a more accurate description of what I'm trying to do on the attached spreadsheet.

Thank you!

Jared