#### hedgie

##### Board Regular

- Joined
- Jun 23, 2004

- Messages
- 160

I have a complicated Nested If statement that basically says the following:

=if(a1="Multiply", b1*d1,if(a1="divide", b1/e1, if(a1="add", b1+f1,b1),c1),0),0)

As the spreadsheet grows, the nesting is growing too. I would like to make a database table which would have the ability to add conditions.

Multiply column 2 * column 4

Divide Column 2 / column 5 etc...

thsi way I can use a simple vlookup and then have a formula applied. Is there a way of using Index and match to accomplish this?