sugarplant
New Member
- Joined
- Feb 18, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I have a table similar to the following, where I have to calculate column E depending on what the equation code is in column A. Different equations require different variables, which are listed in columns B, C, and D. Is it possible to do some sort of VLOOKUP in E that can have a different formula depending on the Equation code in Column A? I have about 19 different equations, so trying to avoid a nested IF function. Thanks!!
A | B | C | D | E | |
1 | Equation # | X | Y | Z | Result |
2 | WW.1 | 1 | 4 | ?? | |
3 | WW.2 | 2 | ?? |