Forum Discussion

Tracie_Barker's avatar
Tracie_Barker
Copper Contributor
Apr 08, 2020

Formula Question

Hello,

 

I wonder if you could help me please. I am trying to create a formula in the attached spreadsheet that will look at the date on the Journal tab and then take the information from that date column on the Summary tab so that when I change the date the information will update.

 

Thanks in advance.

excel
Formulas and Functions

3 Replies

  • Savia's avatar
    Savia
    Iron Contributor
    Apr 08, 2020

    Tracie_Barker You can do this with a relatively simple INDEX MATCH - I have made an example in the attached file.  I have referenced entire rows here to allow you to add more data later; if you don't need that functionality you should consider replacing with references only to the cells you are using.

    • Tracie_Barker's avatar
      Tracie_Barker
      Copper Contributor
      Apr 08, 2020

      Savia 

       

      Thank You, could you please show the formula as it is not letting me see it when I click on your attachment.

       

      Regards

       

      Tracie

      • Savia's avatar
        Savia
        Iron Contributor
        Apr 09, 2020

        Tracie_Barker The formula I made for cell D2 is: =INDEX(Summary!5:5,MATCH('Prepayments Journal'!$D$1,Summary!$3:$3,0))

Resources