Named range formula is not looking up full column, but only under certain criteria.

[DarkJester89]

=OFFSET(INDEX('Formula to pull data'!$T$2:$AE$2,MATCH('Formula to pull data'!$R$3&" "&'Formula to pull data'!$R$4&" "&'Formula to pull data'!$R$5,'Formula to pull data'!$T$2:$AE$2,0)),1,0,INDEX('Formula to pull data'!$T$1:$AE$1,MATCH('Formula to pull data'!$R$3&" "&'Formula to pull data'!$R$4&" "&'Formula to pull data'!$R$5,'Formula to pull data'!$T$2:$AE$2,0)),1)

When R3 cell is set to E-4, R6 (named range drop down) does a full column check.

When R3 is E-5, E-6 or E-7, it does the partial column check, but the formula looks solid

Workbook

Named Range: Rate

Thank you in advance.

 

[Fluff]

The formula is referencing the numbers in row 1, for the height of the column. How are those numbers generated?

 

[DarkJester89]

Ever have one of those days where...you just question like...where did I learn how to do math?

Thanks so much, looking for giants, i ended up getting eaten by the ants.

 

[Fluff]

You're welcome & thanks for the feedback.