Edit:
I believe I solved my riddle by using the Index/Match functions in a nested formula. Will do some more testing this afternoon after I get back from my errands. If my fix continues to work properly I will upload the working spreadsheet and leave a link to the website’s tutorial.
I did some searching online last night and the Vlookup function looked the most promising. I did not understand how it worked even after looking at the examples I found online last night. Will give ye olde online search another go today but any help will be appreciated. 
Wheels