LOOKUP and "nesting" IF formula troubles

Thanks NBVC. I really appreciate the quick response.

Wow, these formulas are pretty involved. I'm looking forward to spending some time this morning trying to figure out what all this language means. I have never used some of these functions but I’m excited to see if I can figure them out without further explanation. This website has become a great educational tool for me in a short time. Thanks again to all those involved!

Of course there is always the chance I come back with a bunch of questions!

I'll respond once I take a closer look.