In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get good understanding of this video. Now he goes on to make a two way look up by connecting cells in different tables and shows how to do it. This video shows how to make a reverse two way look up for date and time in Microsoft Excel.
Have an iPhone? Check out all 200+ new features coming in iOS 13.