I am using excel 2008 for Mac, i need help with the following:
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?
Thanking you in advance.
Specific price depending on the words in 2 cells? please help