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

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

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=529214

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.

"gjcase" wrote:


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

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=529214