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!

Need to use the INDIRECT function when you want to use cell contents as part
of a reference, like so:

=MATCH($L19,INDIRECT(L1),0)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"mooresk257" wrote:

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!