Shawn has to do a four-way lookup: Worksheet, Row, Set of Columns, Column within the Set. To get the correct LOOKUP result, Bill shows a method using INDEX and INDIRECT to solve the problem posed in Episode #1413. Learn Excel 2010 by Bill Jelen
