formula for named cell/range based on cell values
 

hello,

perhaps somebody knows how to do this:

in column A i have different values, for example:

A B
1 aa
2 bb
3 cc

in column B i want to define cells as reference to some named cells located
elsewhere. for example: cell B1: =aatotal and so on in other cells:
bbtotal, cctotal...
how can i define formulas in B column based on values in A in order not to
retype aa bb cc in all the cells. something like B1: =A1total ... ?

thanks,

Alex.

formula for named cell/range based on cell values
 

in B1
=Indirect(A1 & "total")

then drag fill down the column

--
Regards,
Tom Ogilvy

"alex" wrote in message
...
hello,

perhaps somebody knows how to do this:

in column A i have different values, for example:

A B
1 aa
2 bb
3 cc

in column B i want to define cells as reference to some named cells
located
elsewhere. for example: cell B1: =aatotal and so on in other cells:
bbtotal, cctotal...
how can i define formulas in B column based on values in A in order not to
retype aa bb cc in all the cells. something like B1: =A1total ... ?

thanks,

Alex.

formula for named cell/range based on cell values
 

thanks a lot

"Tom Ogilvy" wrote:

in B1
=Indirect(A1 & "total")

then drag fill down the column

--
Regards,
Tom Ogilvy

"alex" wrote in message
...
hello,

perhaps somebody knows how to do this:

in column A i have different values, for example:

A B
1 aa
2 bb
3 cc

in column B i want to define cells as reference to some named cells
located
elsewhere. for example: cell B1: =aatotal and so on in other cells:
bbtotal, cctotal...
how can i define formulas in B column based on values in A in order not to
retype aa bb cc in all the cells. something like B1: =A1total ... ?

thanks,

Alex.