Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I was trying to obtain the result of a formula that is inside of another formula.

|    A    |    B       |    C    |   D   |    E   |
| Option1 | D2-(D2*10%)|         |  10   | Result |
| Option2 | D2-(D2*5%) |         |  14   | Result |
| Option3 | etc etc etc|         |  12   | Result |

Column C is a list of values (values from column A) and depending the option chosen it will print the result in column E. I was doing this with a if statement with allot of conditions if i have allot of options it will not be enough space to write down all the conditions. I did try already to use in column E something like this: =VLOOKUP(C2;A2:B3;2;FALSE) =INDIRECT(VLOOKUP(C2;A2:B3;2;FALSE))

or i did try to use the INDIRECT in the column B...

Any idea how can i do this to avoid huge if statements ?

Thanks in advance

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.