Formula reference to specific cell in named range

[LWGalvan]

In a formula (NOT VBA!) how do I point to a specific cell in a named range? I know I've got to be overlooking it.

Using Excel 2007. Thanks.

 

[barry houdini]

If you have a named range Table and you want to refer to the cell in the 3rd row/5th column of that table you can use INDEX, i.e.

=INDEX(Table,3,5)

 

[LWGalvan]

INDEX, of course! I knew it would be something insanely simple. Thanks for your help.