Help with a search problem

[Aaron_Dexter]

I'm a moderately experienced Excel user, so I'm not real sure how to go about this task:

Currently, my company has a large spreadsheet that lists our on-hand inventory. In order to use up that inventory, we'd like an efficient way of knowing what is on hand.

In order to do this, my manager would like to take the Bill of Materials for a machine, and search the inventory sheet with the part numbers from the BOM sheet - then we would have a third sheet where the matches can be listed so we know what we can use from the inventory for this job.

Is this possible? If more information is needed, let me know what to provide.

Thank You

[martindwilson]

could you attach a sample workbook?