VLOOKUP with a restriction

[Guest]

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

 

[gjcase]

Why not just filter the original list? An autofilter on Category would
get you what you're after, wouldn't it?

---GJC

 

[Guest]

Not really, since there are amny categories, I would have to change the
filter each time, if I want to see all the categories, I am trying to see if
this can be made easier ain a VLOOKUP format.