Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Aug 19, 2010
http://www.contextures.com/xlFunction... In a VLOOKUP formula, you can refer to a lookup table that is in a different Excel workbook. In this example, the price list is in one workbook, and the VLOOKUP formula is in the order data entry workbook. It is easier to create the reference if both Excel workbooks are open when you create the VLOOKUP formula. After you create the VLOOKUP formula, the price list workbook can be open or closed, and the formula will continue to work correctly.