Brandon
The first thing that comes to mind is to use Data - Filter - AutoFilter.
Look that up in Help. The result would be that all the data rows in the
spreadsheet would be hidden except those rows that match your criteria. If
you want the result displayed in any other way or in another place in the
sheet or the file, you will need VBA. Post back with more detail about what
you want. Otto
"brandon roland" wrote in message
...
hello,
another question from the official excel newbie! any and all help is
greatly
appriceated guys!

So I have this list i'm always talking about that has product numbers in
column A, product prices in column B, and order number for the products in
column C ... most products have more than once instance.. for example

product a 10.99 345353
product a 11.99 3445453
product a 10.99 657567
product a 8.99 345353
product a 10.99 5464646

so what I'm trying to do now is , when i type in the product
number(products
are alphanumeric w/ no spaces - the above is just an example) , I want
excel
to search for all entries matching the product entered (A1:A2000) .. If it
finds the products I would like it to display what order numbers are tied
to
that product number, maybe seprated by commas?

so if i put in D1 that i'm searching for 'PRODUCTA' it would return
something like this...

345353, 3445453, 657567, 345353, 5464646

showing me all the orders for which that product was used...

is this possible and if so, how?

Thanks alot guys!
Brandon Roland