using specific celname and read data from that cell

[Benny_76]

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

[#2 · Accepted solution]

@Benny_76 

You 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.

[#3]

@Hans Vogelaar

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