Name ranges and columns

[Diamond, Mark]

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

 

[Niek Otten]

Hi Mark,

Insert>Name>Define 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

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

 

[Diamond, Mark]

Marvellous. Many thanks.

Mark