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.

Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Feb 14, 2020

Dennis Depoorter 

You may use INDIRECT function to refer to the correct sheet listed in column E.

e.g. try this...

 

In F4

=IF($E4="","",IF($C4,VLOOKUP($A$2,INDIRECT("'"&$E4&"'!$A$2:$J$21"),F$3,0),""))

and then copy it across and down.

Resources