create a discount function in excel

[number]

hi!

I would like to create a series of discount functions in excel based on
a certain product. For example, I am selling 10 brands and each of these
brands has a different discount.
Say that I prepare an economical offer in excel, I'd like a function
that as soon as I digit the name of that certain brand, the cost of
that item, it gives me at once the rate of discount I have for that
specific brand. Does this makes sense?
Say i am selling a sony camcorder, I know that with sony I have 50% of
discount, I would like that when I write any number (the cost of the
item) under the name sony (which excel should recognize) then it would
apply at once a discount.
I know it's quite complicated but I hope someone wll help me thanks!!

 

[Guest]

Is the discount by brand not product i.e. do all ALL Sony products havr (from
your example) a 50% discount?

 

[Tushar Mehta]

Put the name of the product/brand togethe with the discount in a table,
then use the VLOOKUP function. For more check XL help for that
function.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[number]

yes, all the sony products have the same discount.

I have a price list with item name, code, price and discount.

I need to do an economical offer (in another sheet of course) and I
would like that when I type a certain code article, it would give me
its price and its discount, based on the other separate excel scheet.
From a new sheet, I would like to assign a price and a discount to a
given name, based on a list located in another sheet.
How can I do this?
Thank you very much

 

[number]

Sorry guys, I don't really succeed to understand how to apply the
VLOOKUP in what I want to do:

I have a price list with item name, code, price and discount.

I need to do an economical offer IN A SEPARATE SHEET and I would like
that when I type a certain code article, it would give me its price and
its discount, based on the other separate excel sheet.
As far as I am seeing, VLOOKUP cannot connect different sheets can it?

Do I have to use the VBS functions?


I don't want to use access, cause I prepare the economical offers in
excel, so rather than going to look for the price and discount of a
certain article in other excel files, I want to create queries and
assignations and connect databases in excel. I know it is possible to
do it, I just need to find out how.
I know it's a quite difficult operation, anyway,
Thank you very much

 

[Tushar Mehta]

I don't know what you tried with VLOOKUP because it is a simple
application of that function.

Suppose your brand/product name is in column A and the discount % is in
col. B starting with row 2 and going to row 4. Suppose the value you
want to look up is in E2. Then, the formula you want is
=VLOOKUP(E2,A2:B4,2,FALSE)
Adjust the range references to match your own data.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions