software

I am trying to create a lookup on another workbook, I want it to look up
items under certain categories. I currenlty have the following
A b c
Carrots Produce $1.00
Wrap Paper $.15

Etc.

Colum A is the item I want to look up, but I only want it to show items
under one category i.e. Paper.

Is this possible, if so anyone have any ideas or a formula that would work?
Any help would be apprecited.Thanks,Since column C is numeric, SUMPRODUCT will work
=SUMPRODUCT(--(A1:A6=quot;Carrotsquot;),--(B1:B6=quot;Paperquot;),C1:C6)
Or, for another sheet
=SUMPRODUCT(--(Sheet2!A1:A6=quot;Carrotsquot;),--(Sheet2!B1:B6=quot;Paperquot;),Sheet2!C1:C6)
I am assuming there is only on Carrots/Paper record in the table
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;JackRquot; gt; wrote in message
...
gt;I am trying to create a lookup on another workbook, I want it to look up
gt; items under certain categories. I currenlty have the following
gt; A b c
gt; Carrots Produce $1.00
gt; Wrap Paper $.15
gt;
gt; Etc.
gt;
gt; Colum A is the item I want to look up, but I only want it to show items
gt; under one category i.e. Paper.
gt;
gt; Is this possible, if so anyone have any ideas or a formula that would
gt; work?
gt; Any help would be apprecited.
gt;
gt;
gt; Thanks,
gt;
I dont think I got my point across correctly, I have sevral categories,
paper, produce, poultry, frozen etc. and accordingly items in another colums,
prices in another column, what I want is a vlookup, that will only show say
products under paper category, and then be able to give me the price for the
given item in the paper category.

Does this make sense. Aince I have to have all my items in one sheet, with
each item having a different category.

quot;Bernard Liengmequot; wrote:

gt; Since column C is numeric, SUMPRODUCT will work
gt; =SUMPRODUCT(--(A1:A6=quot;Carrotsquot;),--(B1:B6=quot;Paperquot;),C1:C6)
gt; Or, for another sheet
gt; =SUMPRODUCT(--(Sheet2!A1:A6=quot;Carrotsquot;),--(Sheet2!B1:B6=quot;Paperquot;),Sheet2!C1:C6)
gt; I am assuming there is only on Carrots/Paper record in the table
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;JackRquot; gt; wrote in message
gt; ...
gt; gt;I am trying to create a lookup on another workbook, I want it to look up
gt; gt; items under certain categories. I currenlty have the following
gt; gt; A b c
gt; gt; Carrots Produce $1.00
gt; gt; Wrap Paper $.15
gt; gt;
gt; gt; Etc.
gt; gt;
gt; gt; Colum A is the item I want to look up, but I only want it to show items
gt; gt; under one category i.e. Paper.
gt; gt;
gt; gt; Is this possible, if so anyone have any ideas or a formula that would
gt; gt; work?
gt; gt; Any help would be apprecited.
gt; gt;
gt; gt;
gt; gt; Thanks,
gt; gt;
gt;
gt;
gt;

There is an Excel feature called auto-filter. Data gt; Filter gt; Autofilter

You can separately filter any of the columns. For example, if you select
Produce, then only the quot;Producequot; rows will appear and all the quot;Producequot; rows
will appear
--
Gary's Studentquot;JackRquot; wrote:

gt; I dont think I got my point across correctly, I have sevral categories,
gt; paper, produce, poultry, frozen etc. and accordingly items in another colums,
gt; prices in another column, what I want is a vlookup, that will only show say
gt; products under paper category, and then be able to give me the price for the
gt; given item in the paper category.
gt;
gt; Does this make sense. Aince I have to have all my items in one sheet, with
gt; each item having a different category.
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt; gt; Since column C is numeric, SUMPRODUCT will work
gt; gt; =SUMPRODUCT(--(A1:A6=quot;Carrotsquot;),--(B1:B6=quot;Paperquot;),C1:C6)
gt; gt; Or, for another sheet
gt; gt; =SUMPRODUCT(--(Sheet2!A1:A6=quot;Carrotsquot;),--(Sheet2!B1:B6=quot;Paperquot;),Sheet2!C1:C6)
gt; gt; I am assuming there is only on Carrots/Paper record in the table
gt; gt; best wishes
gt; gt; --
gt; gt; Bernard V Liengme
gt; gt; www.stfx.ca/people/bliengme
gt; gt; remove caps from email
gt; gt;
gt; gt; quot;JackRquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I am trying to create a lookup on another workbook, I want it to look up
gt; gt; gt; items under certain categories. I currenlty have the following
gt; gt; gt; A b c
gt; gt; gt; Carrots Produce $1.00
gt; gt; gt; Wrap Paper $.15
gt; gt; gt;
gt; gt; gt; Etc.
gt; gt; gt;
gt; gt; gt; Colum A is the item I want to look up, but I only want it to show items
gt; gt; gt; under one category i.e. Paper.
gt; gt; gt;
gt; gt; gt; Is this possible, if so anyone have any ideas or a formula that would
gt; gt; gt; work?
gt; gt; gt; Any help would be apprecited.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Thanks,
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;