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 in this case paper products.

Any ideas and help would be apprecited

Take a look at this:

http://contextures.com/xlDataVal02.html

Biff

"JackR" wrote in message
...
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 in this case paper products.

Any ideas and help would be apprecited

I tried that and it wont work. Any other ideas

"Biff" wrote:

Take a look at this:

http://contextures.com/xlDataVal02.html

Biff

"JackR" wrote in message
...
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 in this case paper products.

Any ideas and help would be apprecited

I tried that and it wont work. Any other ideas

Hmmm......it should!

Which would you prefer...........one long list or 8 smaller lists, one for
each category?

If you want to use the one long list you'd have to have it sorted by
category.

Let me know and I'll put together a sample file that demonstrates this.

Biff

"JackR" wrote in message
...
I tried that and it wont work. Any other ideas

"Biff" wrote:

Take a look at this:

http://contextures.com/xlDataVal02.html

Biff

"JackR" wrote in message
...
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 in this case paper products.

Any ideas and help would be apprecited

I have a workbook that demonstrates what I think you want.

If you want, send me an email and I will send it to you.


Regards,
Howard

"JackR" wrote in message
...
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 in this case paper products.

Any ideas and help would be apprecited