Find Part number through Macro and output to associated part to certain cell

I was curious, is it possible to use .Find instead of lookups to put data in certain cells?
For example, in the attached file in the search sheet, if I put in a part number in C4 that is listed on the "STS" sheet and hit search, can I output the corresponding code in column B to the "Search" sheet deisgnated areas in columne E (ie E9, E11 and E12) if the part number in C4 is located in the "STS" sheet ?
There is more than 1 instance of the part number in C4 with a different vendor code, for example "G-060045-00".
Or is there a better way to do this through the Macro.