Forum Discussion

Calheiro's avatar
Calheiro
Copper Contributor
May 20, 2024
Solved

Dinamically Return Values From a Column Using A Merged Header Above It as Conditional

Hi, everyone! I need some help with a formula. See, I have the table layout as shown above and I need the "CS Month" (FM) column to return the values from daily CS+IN (Row 2) column dinamical...
excel
Formulas and Functions
office 365
Lorenzo's avatar
Lorenzo
Silver Contributor
May 20, 2024

Hoi Calheiro 

 

Assuming I understood...:

 

in FM3:

=OFFSET(FM$1, ROWS(FM$1:FM2), (TODAY()-$FN$1+1)*5)
  • Calheiro's avatar
    Calheiro
    Copper Contributor
    May 21, 2024
    This worked like a charm. You understood correctly! Thank you very much!
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      May 22, 2024

      Hi Calheiro 

       

      You're welcome & Thanks for providing feedback
      Based on the Excel version you run other/better options might exist... Don't forget to provide this info. next time(s)

       

      Cheers

Resources