View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vince Vince is offline
external usenet poster
 
Posts: 102
Default 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.