11-27-2020 01:22 AM
Is it possible to create a Cell Reference using a formula? For example: If I want the value in Cell B1 to equal the value in Cell A1, can I put in Cell B1 something like, ="B" & 1 - (I know this e.g. formula doesn't work, but is there one that would, please?
Many thanks,
Tom
11-27-2020 03:35 AM
@tomc72 Just enter =A1 in cell B1, or is this not what you want?
Alternatively, you may want to look into the INDIRECT or ADDRESS functions.
11-28-2020 05:14 AM
Hi Riny,
You are right, that is not what I want
However, regarding my core issue, perhaps I could explain myself better:
Say I have a randomly generated letter (say W) and a randomly generated number (say 23). I need a formula in (say A1) that adds the W and the 23 together so that cell AI displays not W23, but instead displays the content of cell W23.
Is that possible?
Many thanks for your help,
Tom
11-28-2020 06:12 AM
Solution11-29-2020 02:23 AM
Hi Riny,
Yes, that´s a great help... I can see how I could work with that. Thank you very much.
Tom
11-29-2020 02:38 AM
@tomc72 You're welcome!