Pulling a list of data from a larger table based on criteria

Hi,

I am trying to automate a spreadsheet for pulling together information on the month's projects and their status's but having difficulty finding how to do what I want - if it is even possible... So any help would be appreciated.

If I simplify the problem to an example that I can explain easier - imagine a spreadsheet of product information, including columns with product number and price. I am trying to create a list of product numbers based on one or two price criteria. I need the list of product numbers so that I can then use formulae to pull in other related data I need but I can't work out how to get excel to give me a list - I tried using lookup but that seems to only be able to find one value at a time?

It will end up being used so that the 'price' constraints will be referenced from a cell value so that a data table based on the price value can be pulled together, and the whole thing is automated rather than someone sorting for each of three criteria seperately and then copy/pasting the relevant data each month.

Is this possible with formulae or will I need to look into visual basic (which I haven't used before), or is it simply not possible to do something like this?

Thanks