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