Need help combining multiple if Vlookup statements on multiple concatenated keys

i attached a sample sheet. the columns in Green have the Vlookups. I had to remove some of the Vlookups b/c the file size exceeded the 1MB limit, but this should give an idea of what I'm looking for. I want to have one column that can run all of the Vlookups with the various key concatenations they look for and return the match from whichever one finds a match.