how to skip to next cell to lookup info until found
 

Hi,
I am setting up several inventory sheets based on my spreadsheet that I have
created in Excel. In my list of items I have approx. 60 different items. I am
trying to seperate them and put them into categories based on the numbers 1
thru 60 which I have placed in a cell to the far left of my spreadsheet.
Example: 1= steel, 2=alum, 3= stainless steel.
I want my inventory sheets to stay current automatically so when it is time
for inventory all I have to do is hit print and hand it to the appropriate
person(s) that will be counting in that specific area. So I want to set up a
formula that will list all the items that are listed under the code #1 and
code #2 and so on but skip the other codes it finds. I hope that I am not
being confusing. If there is any other info needed please ask.
Thanks.
--
excel user