- Feb 8, 2012
- Office Version
Hello friends, I was looking for a solution on the Internet, but I could not find what I needed. I have a drop-down menu with 4 words (for example: Analgin, Aspirin, Tree, Flowers) in cell b1. When I choose a word, I want to take specific values from specific cells, for example from a1 x a3 + b3 / a5 - for Analgin. Or for Aspirin a1 * a3 + b4 / b2 - c2, etc. for the other selected words. The result is in cell b10, no matter what I choose. I will be grateful if anyone can help me.