I have 2 tables, one table i have information about the product name,
category and price. so a product can be CAT a,b,c or d

The second table has information about the percent i want of the product
price in the 1st table.

SO i need to do a statemant saying if product in table 1 is category Ab,c or
d then choose the percent in table 2 for cat A, b, c, or d and multiply it by
the price from table 1

If I understand your requirement, VLOOKUP (or INDEX) is a better solution.

Can you give examples of your tables and the "lookup" you require?

HTH

"mo" wrote:

I have 2 tables, one table i have information about the product name,
category and price. so a product can be CAT a,b,c or d

The second table has information about the percent i want of the product
price in the 1st table.

SO i need to do a statemant saying if product in table 1 is category Ab,c or
d then choose the percent in table 2 for cat A, b, c, or d and multiply it by
the price from table 1