Row Reference in Formula from Cell Entry?
Posted on 2011-05-10
If I wanted to use 3 cell entries to set the page reference, along with starting row and ending row in the following formula, how would I do it?
The columns for now are static on all sheets
=INDEX('Question 12'!A4:A7,MATCH(MAX('Question 12'!D4:D7),'Question 12'!D4:D7,0))
So, that I can use say
Cell A1 = Question 12
Cell B1 = 4
Cell C1 = 7
And have the formula reference those to build itself?