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