I am making a Program search tool for my company. I would like the operator to type a part number into a cell. If the part number is valid (from a master list on a different sheet), then I would like to pull the information from the master list and populate a few cells on the search worksheet.

Example:

An operator types: "W3303-01" in a cell and clicks a button.
The macro would populate cells on that worksheet with information from another worksheet that pertains to "W3303-01"

Thank you!