Forum Discussion
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...
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.
Thank You, could you please show the formula as it is not letting me see it when I click on your attachment.
Regards
Tracie
Tracie_Barker The formula I made for cell D2 is: =INDEX(Summary!5:5,MATCH('Prepayments Journal'!$D$1,Summary!$3:$3,0))