Well, I thought I was good at Excel until you asked this question. I thank you kid sir for proving to me that I am dumber than I appear.
No problem lol, shagwag3n's suggestion of using vLookup worked, but it was a bit tedious. However, it got the job done. I just wish there was some other even quicker way.