Named Ranges - accessing a cell

M

mojoweiss

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