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" <[email protected]> wrote in message
news:[email protected]...
> 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!