General Ledger
Active Member
- Joined
- Dec 31, 2007
- Messages
- 460
Dear All,
Using Excel 2007: I used the Concatenate function to create a string that looks like a formula. I need a function that converts the string to a formula. I don't want to use VBA or macro.
For example, in cell A4 is the formula =CONCATENATE("=",A1,"!",A2,A3) Where A1 is the name of a sheet such as January, where A2 is a letter such as Z that is a column reference, and where A3 is a number such as 100 that is a row reference. The Concatenate function returns a string =January!Z100 I want Excel to interpret this string as a formula and show the value from sheet January, cell Z100.
It seems this should be easy but I can not find the solution. I almost wish the answer is complicated so I don't think I am so stupid. If someone provides a simple solution, I might have to surrender my Microsoft Certified Trainer and Certified Application Specialist certificates.
Best regards,
General Ledger
Using Excel 2007: I used the Concatenate function to create a string that looks like a formula. I need a function that converts the string to a formula. I don't want to use VBA or macro.
For example, in cell A4 is the formula =CONCATENATE("=",A1,"!",A2,A3) Where A1 is the name of a sheet such as January, where A2 is a letter such as Z that is a column reference, and where A3 is a number such as 100 that is a row reference. The Concatenate function returns a string =January!Z100 I want Excel to interpret this string as a formula and show the value from sheet January, cell Z100.
It seems this should be easy but I can not find the solution. I almost wish the answer is complicated so I don't think I am so stupid. If someone provides a simple solution, I might have to surrender my Microsoft Certified Trainer and Certified Application Specialist certificates.
Best regards,
General Ledger