You could combine the size and product in a helper column which is
some way to the right of your price list (eg column Z), so that it
won't be seen.

Then you could use an INDEX/MATCH combination to get the Price.

But anyway, what is wrong with a price list like this:

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

?

Hope this helps.

Pete

On Apr 22, 4:47*pm, katiapro93
wrote:
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?