Want help in Excel

  • Thread starter Thread starter Honey Brar
  • Start date Start date
H

Honey Brar

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
 
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
 
Thanks
One thing is that when i am trying to insert table in sheet 2 then it wants
data then the data is in sheet 1 but i am not able to select the sheet 1 what
can i do
thanks in advance
if you want to send some excel file then here is my email address
(e-mail address removed)
 
Hi,
if you are in sheet 2 and you want a formula to select something from sheet
1 you need to use
Sheet1!A1, this is an example change the range you need
 
Back
Top