How to Do a reverse two way look up in Excel
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.