DarkJester89
Board Regular
- Joined
- Nov 5, 2017
- Messages
- 109
- Office Version
- 2016
- Platform
- Windows
Excel Formula:
=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.