| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
