Most valuable professional
  • Hot Topics

Excel Accomodate Range in INDEX, INDIRECT

My formula reads like the following =INDEX(INDIRECT("'"&LOOKUP(A5,tt)&"'!A1:A20"),MATCH(D1,INDIRECT("'"&LOOKUP(A5,tt)&"'!B1:B20"),0)) where 'tt' is a table name B1 to B20 contains data that is both as single numbers as well as ranges - - 0 1 2/3/2014 4 5/6/2014 7 8 9/10/2014 11 12/13/2014 14 15 16-17 18 19-20 21

This question generated 31 answers. To proceed to the answers, click here.

This thread is current as of November 24, 2013.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel