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
add comment

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.