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.