Excel Guru's

Associate
Joined
13 Aug 2012
Posts
128
Location
Yorkshire
Hi

Are there any excel ace's who can lend me their assistance. I can't figure out how to add a formula to a drop down option.

The formula for working out the total cost isn't an issue

For example I have 2 sheets within an excel document.

Sheet 1 is called 'Key' in here are all the variables such as, Item1, Item2 etc with their corresponding postage costs, margin etc.

Sheet 2 is 'Calculator' where I would like to be able to select item1 or item2 etc from a drop down. Input the cost price and have it calculate the list price.

So if anyone knows how can I assign my item category a certain formula then have the calculator pull that in when the option is selected would be saving me a massive headache :D
 
I think all you would need to do would be to use a formula in the result cell that, for example, multiplied the inputted cost amount by a looked up value from the data tab - this lookup could be done simply with a VLOOKUP?

 
Last edited:
You need to use "Data Validation" follow this

Data > Data Validation > "Allow" = List > select the items that you wish to appear on that list then the job is a gooden, you could also have a vlookup then next to it in order to bring back the price.
 
Ok. I get the idea but I've having no luck.

It currently looks like this in my data tab:

XZe1lpF.jpg


And this in my calc tab:

ltZTvdT.jpg


You can see the formula that is in place for the retail tab. I've added the drop down but can't seem to work out how to get the formula to work.
 
Back
Top Bottom