Need Help creating a Search Option within Excel

[ksspoon]

Creating a catalog with item numbers, description and prices. Would like to be able to type a item description on first sheet of workbook and it pulls the item number, description and price from sheet 2 in the same workbook. Is this possible?

[Andrew_Harris]

This is very possible. Depending on the format of the data in sheet 2 you could probably get by with a few vlookups. Could you post the workbook?

[ksspoon]

Here is an example of what I would be using and what I would like the search result to be.