noodlestall
New Member
- Joined
- Apr 5, 2018
- Messages
- 2
I currently use:
which works fine.
However I want to make this as dynamic as possible and as easy as possible for the user to amend with no knowledge of the formulas used at all. I have a hidden row above my table with the column headers in the Raw data, this is then used to look up a column index. I have one more look up that I want to do to make this fully dynamic
In my raw data this is column is column 40 (AX).
how can I get a formula to use that number (40) in the current match function (or alternative) please?
Code:
=IFERROR(INDEX('Risk Raw Data'!$A$1:$BJ$600,MATCH($B7,'Risk Raw Data'!$AN$1:$AN$600,0),MATCH(F$5,'Risk Raw Data'!$A$1:$BJ$1,0)),"")However I want to make this as dynamic as possible and as easy as possible for the user to amend with no knowledge of the formulas used at all. I have a hidden row above my table with the column headers in the Raw data, this is then used to look up a column index. I have one more look up that I want to do to make this fully dynamic
Code:
=IFERROR(INDEX('Risk Raw Data'!$A$1:$BJ$600,MATCH($B7,[U][I][B]'Risk Raw Data'!$AN$1:$AN$600[/B][/I][/U],0),MATCH(F$5,'Risk Raw Data'!$A$1:$BJ$1,0)),"")In my raw data this is column is column 40 (AX).
how can I get a formula to use that number (40) in the current match function (or alternative) please?
