View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
katiapro93 katiapro93 is offline
external usenet poster
 
Posts: 4
Default Using V or H lookup

Hi,

I have a chart which is a price list. in one column I have the size of the
product, next to it is a column with the product name, and next to it is a
column with its price. I want to do a form which looks up a product and
gives me the price. Only problem is that we have alot of the same product
names and sizes. How can I have excel look it up. I thought maybe combining
the size and product columns but that would mess up my Price list.

Example:

12oz Whole Jal Price
26oz Whole Jal Price
12oz Sliced Jal Price
26oz Sliced Jal Price

Can anyone help me?