search tool

[Arney]

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!

[shg]

Welcome to the forum.

You can just use VLOOKUP formulas to retrieve the information from a table indexed by part number.

[Arney]

This solution worked great!! Thanks,

[royUK]

In addition use Data validation to create a drop down list of part numbers to choose from

http://excel-it.com/data_validation.htm