SOLVED

using specific celname and read data from that cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1865390%22%20slang%3D%22en-US%22%3Eusing%20specific%20celname%20and%20read%20data%20from%20that%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1865390%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20trouble%20finding%20the%20right%20command%20to%20get%20something%20done.%20Something%20pretty%20simple%20I%20guess%20but%20I%20can't%20seem%20to%20find%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20made%20a%20sheet%20where%20I%20changed%20the%20cellnames%20to%20specific%20names.%20Now%20I%20can%20find%20these%20values%20everywhere%20by%20just%20typing%20in%20another%20sheet%20'%3D%22CELLNAME%22.%3CBR%20%2F%3EIn%20another%20sheet%20I'm%20also%20creating%20cells%20with%20text.%20So%20if%20the%20name%20is%20made%20correct%2C%20then%20I%20would%20like%20it%20to%20extract%20there%20(or%20a%20cell%20next%20to%20it%20if%20I%20cannot%20pull%20it%20out%20immediately)%20the%20value%20of%20the%20cell%20from%20the%20other%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20I%20miss%20the%20finesse.%3C%2FP%3E%3CP%3EI%20can%20create%20the%20exact%20name%2C%20but%20I%20don't%20manage%20to%20READ%20the%20value.%20I%20don't%20know%20how%20to%20give%20the%20command%20of%20reading%20the%20cell%20with%20that%20specific%20name...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20has%20an%20answer%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThx%20for%20any%20hints%20or%20solutions!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBenny%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1865390%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1865456%22%20slang%3D%22en-US%22%3ERe%3A%20using%20specific%20celname%20and%20read%20data%20from%20that%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1865456%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F861890%22%20target%3D%22_blank%22%3E%40Benny_76%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20the%20INDIRECT%20function%20for%20this.%20Let's%20say%20you%20have%20a%20cell%20name%20in%20cell%20A2.%3C%2FP%3E%0A%3CP%3EIn%20another%20cell%2C%20for%20example%20B2%2C%20enter%20the%20formula%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DINDIRECT(A2)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EThis%20will%20return%20the%20value%20of%20the%20cell%20whose%20name%20is%20in%20cell%20A1.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1865848%22%20slang%3D%22en-US%22%3ERe%3A%20using%20specific%20celname%20and%20read%20data%20from%20that%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1865848%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%3C%2FP%3E%3CP%3EIt%20works!!%20Thanks%20a%20lot!%20I%20thought%20it%20couldn't%20be%20a%20big%20deal%20but%20if%20ons%20doesn't%20know%20the%20trick...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EBenny%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 Replies
Highlighted
Best Response confirmed by Benny_76 (New Contributor)
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.

Highlighted

@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