### Excel 2010 Magic Trick 800: Alter VLOOKUP Table To Simplify Formula To Return Multiple Items

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm Rotate Table: 1. See how to add blank formulas and a row with a zero lookup to the lookup table to help simplify the VLOOKUP function formula 2. See COLUMNS function to increment numbers in a formula to generate column index numbers for VLOOKUP function.

Length:
06:27