hedgie
Board Regular
- Joined
- Jun 23, 2004
- Messages
- 174
- Office Version
- 365
- Platform
- Windows
I can't seem to find this in the archives.
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?
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?