Help with a formula
 

Cell H18 contains an account number such as 11-10-80808-61510. Cell K18
contains the formula =(Actuals61510), which is a defined name.

I would like for cell K18 to show the data for whatever account may be in
cell H18 based on the last five digits. I tried entering into cell K18 the
formula ="Actuals" & Right(H18,5) but is merely concatenates the two and
puts that in the cell.

Is there a way to create a dynamic formula such as what I am looking for?

Your help is appreciated.

Help with a formula
 

=INDIRECT("ACTUALS"&RIGHT(H18,5))
--
John C


"Vince" wrote:

Cell H18 contains an account number such as 11-10-80808-61510. Cell K18
contains the formula =(Actuals61510), which is a defined name.

I would like for cell K18 to show the data for whatever account may be in
cell H18 based on the last five digits. I tried entering into cell K18 the
formula ="Actuals" & Right(H18,5) but is merely concatenates the two and
puts that in the cell.

Is there a way to create a dynamic formula such as what I am looking for?

Your help is appreciated.

Help with a formula
 

Thank you very much John. That worked perfectly.

"John C" wrote:

=INDIRECT("ACTUALS"&RIGHT(H18,5))
--
John C


"Vince" wrote:

Cell H18 contains an account number such as 11-10-80808-61510. Cell K18
contains the formula =(Actuals61510), which is a defined name.

I would like for cell K18 to show the data for whatever account may be in
cell H18 based on the last five digits. I tried entering into cell K18 the
formula ="Actuals" & Right(H18,5) but is merely concatenates the two and
puts that in the cell.

Is there a way to create a dynamic formula such as what I am looking for?

Your help is appreciated.