M
mooresk257
I have a named array "EAP" which I am using the MATCH function to find if a
value in a cell is contained in the list.
Ex. 1
=MATCH($L19,EAP,0)
The name of the array is in cell L1. I'd like to make this formula relative
so that as I copy it to other cells, the named array will be the name in the
cell in the first row:
Ex. 2
=MATCH($L19,L1,0)
However, while the formula in the first example works, the formula is the
second does not. Is there a way I can reference an array name using the
contents of a cell?
Thanks!
value in a cell is contained in the list.
Ex. 1
=MATCH($L19,EAP,0)
The name of the array is in cell L1. I'd like to make this formula relative
so that as I copy it to other cells, the named array will be the name in the
cell in the first row:
Ex. 2
=MATCH($L19,L1,0)
However, while the formula in the first example works, the formula is the
second does not. Is there a way I can reference an array name using the
contents of a cell?
Thanks!