Referencing a named array

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!
 
L

Luke M

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top