Solved/Closed
JoeyM - Dec 19, 2015 at 03:18 AM
JoeyM - Dec 20, 2015 at 06:34 PM
Hello,

I am using excel 2008 for Mac, i need help with the following:

example:
A1 has a drop down box of 3 choices, apples, pears and peaches
A2 has a drop down box of 3 choices, .5kg, 1kg and 5 kgs
how do i make the relevant price appear in A3 depending on the combination chosen?

Related:

## 2 responses

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Dec 19, 2015 at 11:31 AM
How much do each of the products cost?
lets say they cost \$3 per kg, thanks.
in that case simply multiply the chosen value in A2 by 3 as the product is not relevant.
Apologies, the product is relevant, what i should have said was:
Apples = \$3 per kg
Pears = \$5 per kg
Peaches = \$8 per kg
Thanks Ray, thats awesome, problem solved. :)
MdRiyadHasan Posts 1 Registration date Friday December 18, 2015 Status Member Last seen December 19, 2015 1
Dec 19, 2015 at 08:57 AM
i thing....a3- 1kg peaches= price 10tk...