Excel Question

[Maxflyer]

I am working on an excel spreadsheet where I have a range of headings:

Order no: Date In: Type: Qty: Date Out: Price: Per unit: Total:

I have a seperate worksheet with a list of products by Type: Description: Price:

Is there an easy way to enter a type number into the first sheet and then Excel to automatically look at the other worksheet and pull out the description and price?

Hope this makes some sort of sense.

Thanks in advance.

MF