Thanks, this is getting me closer to what I want, I can combine the 2 columns
as a helper but then I have never used the Index/Match functions, can you go
into it a little for me. I know I can look it up under help but I figured
you would get me straight to the point.

"Pete_UK" wrote:

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?