Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Feb 8, 2010
See how to use the INDIRECT, TEXT, SUBSTITUTE, Named Ranges, Create Name From Selection, and Space Operator to do a two way lookup when the named ranges contain dates. Then see a much better method using VLOOKUP and MATCH functions. See this video: Excel Name Trick #7: INDIRECT function, Names and LOOKUP