Forum Discussion
Ultra_Tech
Nov 05, 2020Copper Contributor
How to auto-populate several different formula
Hi guys! Is there a way to auto populate different formulas into a cell depending on what is selected (from a drop down list) or entered into a previous cell? For example, I have 4 different se...
- Nov 05, 2020
There is different logic in your post and the sample. Based on post we simply ignore V1, as variant
In sample V104 is transformed to 4 and V162 to 162, the logic of that is not clear. Could you please sync and define the logic in more formal way.
SergeiBaklan
Nov 05, 2020Diamond Contributor
There is different logic in your post and the sample. Based on post we simply ignore V1, as variant
In sample V104 is transformed to 4 and V162 to 162, the logic of that is not clear. Could you please sync and define the logic in more formal way.
- Ultra_TechNov 05, 2020Copper Contributor
Apologies for the confusion. But you nailed it!
I was able to use that formula and just drag it down the entire column.
Thanks a million! 🙂
- SergeiBaklanNov 05, 2020Diamond Contributor
Ultra_Tech , you are welcome