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.

in B1
=Indirect(A1 & "total")

then drag fill down the column

--
Regards,
Tom Ogilvy

"alex" <[email protected]> wrote in message
news:[email protected]...
> 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.

thanks a lot

"Tom Ogilvy" wrote:

> in B1
> =Indirect(A1 & "total")
>
> then drag fill down the column
>
> --
> Regards,
> Tom Ogilvy
>
> "alex" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>