Name ranges and columns
 

I'm using MS Office Excel 2003. I'd like to be able to refer to a column by
a name so that I could use 'Price'23 instead of C23 and so forth. I thought
that I'd be able to do that by highlighting the column and then using
Insert-Name-Define or similar (I can't figure out the difference between
the Name-Create, Name-Define and Name-Label variations.

In any case, none of them seem to allow the kind of construction I'd like.
Do I have the syntax wrong in Price23 (for example ... how to separate
column and row parts) or is the whole thing impossible?

Cheers,

Mark

Name ranges and columns
 

Hi Mark,

InsertNameDefine is the right one.

If you then use =Price, it will take the price from the same row.
To take the price from another row, use the intersection operator; a space. Like in

=Price 5:5

Or, if a row is named Fruit:

=Price Fruit


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Diamond, Mark" wrote in message ...
| I'm using MS Office Excel 2003. I'd like to be able to refer to a column by
| a name so that I could use 'Price'23 instead of C23 and so forth. I thought
| that I'd be able to do that by highlighting the column and then using
| Insert-Name-Define or similar (I can't figure out the difference between
| the Name-Create, Name-Define and Name-Label variations.
|
| In any case, none of them seem to allow the kind of construction I'd like.
| Do I have the syntax wrong in Price23 (for example ... how to separate
| column and row parts) or is the whole thing impossible?
|
| Cheers,
|
| Mark
|
|

Name ranges and columns
 

Marvellous. Many thanks.

Mark


"Niek Otten" wrote in message
...
Hi Mark,

InsertNameDefine is the right one.

If you then use =Price, it will take the price from the same row.
To take the price from another row, use the intersection operator; a
space. Like in

=Price 5:5

Or, if a row is named Fruit:

=Price Fruit


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Diamond, Mark" wrote in message
...
| I'm using MS Office Excel 2003. I'd like to be able to refer to a column
by
| a name so that I could use 'Price'23 instead of C23 and so forth. I
thought
| that I'd be able to do that by highlighting the column and then using
| Insert-Name-Define or similar (I can't figure out the difference
between
| the Name-Create, Name-Define and Name-Label variations.
|
| In any case, none of them seem to allow the kind of construction I'd
like.
| Do I have the syntax wrong in Price23 (for example ... how to separate
| column and row parts) or is the whole thing impossible?
|
| Cheers,
|
| Mark
|
|