Hi Fellas,

Quick one for you - I've named a bunch of 1x100 arrays and am using them to index match data across them.

For example: I Use: Index(Array1,match(a1,Array1,0),1) to search the A1 value within Array and return the relative location of the variable in A1.

Is there away for me to continue to Array1 but instead of typing in "Array1" to be able to link it a cell, say B1, which I can modify so the array can be called Array1, Array2, ArrayN?

1.) I basically want to be able to type in the name of the array and search across. Will the address function allow me to do this? How would I go about doing this?

2.) Is the computationally efficient? Are there more efficient ways of doing this without going all fancy schmancy VBA.

Thanks,

Larry