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