It's not particularly pretty, but you could concatenate INDEX/MATCHES.
I'd recommend using TRIM on your headers, as they all have a number of spaces after each string.
This will cause errors if you type model C232 and try to find a match against "C232 " which is what is in there now.
In my attached version, I took the liberty of removing the trailing spaces.
Here's the final formula I used:
K20,K21,K22,K23,K24 are model numbers, and the value in K27 is the part.
partsmodel.png
partsmodel - concatenation.xlsx
Bookmarks