Main Profile

At A Glance

Excel Magic Trick 898: Lookup Row of Data and Display Items Vertically: INDEX INDEX Lookup Formula

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to lookup Lot number and display the items associated with the lot number vertically: 1. INDEX and MATCH to retrieve a row of data 2. Then use a second INDEX to lookup elements in the "looked up row" and display the items vertically using the ROWS Function 3. Jon Wittwer's Excel Tips Blog: Be sure to use INDEX with column number index so that formula will work in programs like Open Office
Length: 07:30

Contact

Questions about Excel Magic Trick 898: Lookup Row of Data and Display Items Vertically: INDEX INDEX Lookup Formula

Want more info about Excel Magic Trick 898: Lookup Row of Data and Display Items Vertically: INDEX INDEX Lookup Formula? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question