Most valuable professional
  • Hot Topics

Excel Formula Reduction

I have another three formulas I'm hoping someone can review and provide feedback on: 1) Array formula: =IF($A3="","",INDEX(Inputs!$B:$S,SMALL(IF(Inputs!$B:$B=$A$1,ROW(Inputs!$B:$B)),ROW(1:1)),COLUMN(C1))) 2) Array formula: =IFERROR(INDEX(Inputs!$A:$S,SMALL(IF(Inputs!$A:$A=$A$1,ROW(Inputs!$A:$A)),ROW(1:1)),COLUMN(B1)),"") 3) =IF($A3="","",INDIRECT("'Inputs'!"&ADDRESS(MATCH($A$1,Inputs!$A:$A,0),COLUMN(C1),4))) Suggestions on how to make any of these better? Ryan

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

This thread is current as of February 25, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel