I'm using the index match formula as my lookup formula:
INDEX('All SCC Ready to Import'!$A$2:$A$800,MATCH('LocalStateSCC Falcon Positions'!H30,'All SCC Ready to Import'!$E$2:$E$800,0))
I would like to make this lookup dynamic without having to change the range from A2 :A1000 for example.
I...