Hi,
Let's say you have the name in cell A2, the price in B2 and you want the
price to be multiplied by a constant in C2. First you need to create a table
with the names and the constant let's say in sheet2, then hide the sheet and
protect your workbook so nobody can see it and use the formula as follow in C2

=B2*SUMPRODUCT((A2=Sheet2!A:A)*Sheet2!B:B)

if this helps please click yes thanks


"Honey Brar" wrote:

Please answer this Qustion ASAP
In Microsoft Excel, Suppose in a name field i write name and in price field
i write price*some constant. this constant is different for different name. i
want is that this constant cannot be seen to any body but it must multiply by
price with match to the name
Main thing is that tis constant must recognize the name and when the name
matches it will automatically multiply the price with that constant

Thanks in Advance
Honey Brar