So it looks like I have a few errors in my formula to begin with which
caused the issue.

I appreciate the second set of eyes on my formula, and I learned that
you can nest VLookup (if you have the right ranges!).

Thanks for everyone's help.