Forum Discussion

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...

Prepayments Schedule 2020-2021.xlsx14 KB

excel

Formulas and Functions

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

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))