Named Ranges - accessing a cell
 

If I name a range, let's say 'Dog', is there a way that I can access specific
values in the named section?

If 'Dog' is a 10x10 matrix, I want to be able to access the value in third
row and fourth column of dog. I thought it would be something like this:

=Dog(3,4)

But that doesn't work.
Thanks for help!

mojoweiss,

=INDEX(Dog,3,4)

HTH,
Bernie
MS Excel MVP


"mojoweiss" wrote in message
...
If I name a range, let's say 'Dog', is there a way that I can access specific
values in the named section?

If 'Dog' is a 10x10 matrix, I want to be able to access the value in third
row and fourth column of dog. I thought it would be something like this:

=Dog(3,4)

But that doesn't work.
Thanks for help!