I have a list of items, with categories, prices and other information as
follows,

A B C

ITEM CATEGORY PRICE

There are different categories depending on the item, what I need to have is
a VLOOKUP formula tha will do the following

On different workbook and sheet In column A I want to have a drop down list
that will only show items in one category, i.e. "Paper products", and show
only the paper products, when I select the item, I need the price looked up
and placed in colum B.

The main list has over 300 items, in about 8 categories, for this particular
Lookup I only want it to show one category.

Any ideas and help would be apprecited