Forum Discussion

Dennis Depoorter's avatar
Dennis Depoorter
Brass Contributor
Feb 14, 2020
Solved

Change formula based on imput

I like to change a formula based on the input of a cell.   I have a list with 2 company's: COMPANY1 and COMPANY2 If I select COMPANY1, the formula has to retrieve data from tab COMPANY1 If I sele...
excel
Formulas and Functions
  • Savia's avatar
    Savia
    Feb 14, 2020

    Attaching a modified file with a suggested variable formula in Row 1.  This same approach could be used for the rest.

Savia's avatar
Savia
Iron Contributor
Feb 14, 2020

Attaching a modified file with a suggested variable formula in Row 1.  This same approach could be used for the rest.

Dennis Depoorter's avatar
Dennis Depoorter
Brass Contributor
Feb 14, 2020

Savia  THANKS!!! now I'll try to understand the formula

Resources