Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accessing named ranges in Excel from VBA | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
Named Cell Ranges | Excel Discussion (Misc queries) |