I have two table ranges in excel. One will have the conditions and equivalent formulas to be used for those conditions. And in other table, I have conditions and their input values that should be given to the formulas. I need to substitute the inputs with the relevant condition formula and get the output. How to do it directly in MS excel without using VBA
enter image description here
enter image description here
enter image description here
I’ve tried using What if analysis and Lambda formulas. But in anymeans I couldn’t get that.
New contributor
user25427457 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.