Reverse VLookup?

I create a SKU Generator using vlookup so when I put specific variables in table 1, it's going to pick up the codes for that variable in table 2. Since I have 7 variables, i concatenated the codes to form 1 single SKU code. I used the code below (let me know if there's an easier way of doing it). I wanted to check if it's possible to do a "reverse lookup" where when i enter a SKU in a cell, it's going to return a concatenated value of all variables?

Screen Shot 2020-01-23 at 5.16.54 PM.png

=CONCATENATE((VLOOKUP(A3,Codes!A3:B5,2,FALSE)),(VLOOKUP(B3,Codes!C3:D12,2,FALSE)),(VLOOKUP(C3,Codes!E3:F103,2,FALSE)),(VLOOKUP(D3,Codes!G3:H5,2,FALSE)),(VLOOKUP(E3,Codes!I3:J147,2,FALSE))," - ",(VLOOKUP(F3,Codes!L3:M8,2,FALSE)),(VLOOKUP('SKU Generator'!G3,Codes!N3:O11,2,FALSE)))

you can't enter a value in a cell AND also have a formula in it. You can do a reverse lookup using index/match but that would require taking apart your vlookup and trying to work it backwards. A sample workbook would go a long way toward getting a working formula. Follow the instructions in the yellow banner at the top of the post to upload one, AND be sure to include some expected results.