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.