I have a nested IF statement that I need to expand if a new column is added which happens often. Wondering if there is a better way to handle this?
Here's my formula
=IF($A$4=$D$4,$D7,IF($A$4=$E$4,$E7,IF($A$4=$F$4,$F7)))
If works perfectly, except I will be adding a column G next month and...