VLOOKUP with a restriction
 

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

VLOOKUP with a restriction
 

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

VLOOKUP with a restriction
 

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