Nov 08 2020 01:31 PM
Hi,
I'm having trouble finding the right command to get something done. Something pretty simple I guess but I can't seem to find it.
I've made a sheet where I changed the cellnames to specific names. Now I can find these values everywhere by just typing in another sheet '="CELLNAME".
In another sheet I'm also creating cells with text. So if the name is made correct, then I would like it to extract there (or a cell next to it if I cannot pull it out immediately) the value of the cell from the other sheet.
There I miss the finesse.
I can create the exact name, but I don't manage to READ the value. I don't know how to give the command of reading the cell with that specific name...
Anyone has an answer?
Thx for any hints or solutions!
Benny
Nov 08 2020 02:37 PM
SolutionYou can use the INDIRECT function for this. Let's say you have a cell name in cell A2.
In another cell, for example B2, enter the formula
=INDIRECT(A2)
This will return the value of the cell whose name is in cell A1.
Nov 08 2020 09:36 PM
It works!! Thanks a lot! I thought it couldn't be a big deal but if ons doesn't know the trick...
Best regards,
Benny
Nov 08 2020 02:37 PM
SolutionYou can use the INDIRECT function for this. Let's say you have a cell name in cell A2.
In another cell, for example B2, enter the formula
=INDIRECT(A2)
This will return the value of the cell whose name is in cell A1.