Hi

I would like to setup a database for our company that would hold all of our
purchased in parts.

I want to have 3 main headings. "Raw Material Numbers" - "Description" -
"Category"

I want to be able to search by either Raw Material Number or Category. Lets
say I have a RAw material number I want to search. I will input that number
under "Raw Material Numbers" and excel will search the database and find the
number and return the Description and Category. That part I think I have
down, it's the next part that gets me.

I also want to search by category. Lets say I have 5 categories, "Nuts",
"Bolts","Washers","Cotter Pins", and "Gaskets". I might want to search for a
Washer's "Raw material number". So I select to search by the Category
"Washers", and excel will return all numbers, descriptions in that category.

I am sure this is possible, just have no clue how to do it. Is there already
a template that would work, or that I could modify??

TIA
XP Small Business