Search through a string of text for a specific value and relate it to a horizontal value

I am trying to create a script that allows me to type in the unique ID in a cell and have it spit out the value of the product name in the horizontal row corresponding to the unique ID. The main catc...