Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on May 21, 2011
Download file: https://people.highline.edu/mgirvin/E... 1. See how to do a three way lookup when there are two row header variables (criteria) and one column header (criteria) variable using INDEX and MATCH functions for a normal two way lookup, but with the two row headers joined to create a single row header criteria. In essence, three way lookup is turned into a standard two way lookup. Also see IFERROR function.