referencing another cell

[JOEE1979]

I am using a name manager to get the color for the cell of the table on the left (yellow/orange).
Is there a way I can get the color code to show on the right table?
That way, I can modify the left table as I please and the right table will pick it up (refresh)
The formula I have in the name manager is =GET.CELL(63,INDIRECT("RC",0)) it is named "qq"
I tried in cel "P6" =qq(E6), but it didn't work

HOS.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
4	BODY PERSON - Streetsville											BODY PERSON - Streetsville
5	BADGE #		NAME	12-Apr	19-Apr	26-Apr	03-May	10-May	17-May	24-May		BADGE #		NAME	12-Apr	19-Apr	26-Apr	03-May	10-May	17-May	24-May
6	1	5143										1	5143
7	2	5235										2	5235
8	3	5134										3	5134
Sheet1

 

[awoohaw]

does the formula work for you when you have it in a cell and not in a range name?

 

[JOEE1979]

does the formula work for you when you have it in a cell and not in a range name?

yes, if I type =qq in the colored cell, I get the code

 

[awoohaw]

yes, if I type =qq in the colored cell, I get the code

What version of excel are you using? I do not have a GET() function?

 

[JOEE1979]

What version of excel are you using? I do not have a GET() function?

365

 

[awoohaw]

365

That is what I have. Is it some kind of add on? If so, maybe that is why it cannot be incorporated with the Name Manager? But, it is over my pay grade. I'm sorry I have muddled your post and hope some other folks respond.

 

[Alex Blakenburg]

@awoohaw - its a legacy Macro4 command. I think it only works if you put it in name manager.

@JOEE1979 - will this work for you ?

=GET.CELL(63,INDEX(Sheet1!$D7:$J7,1,MATCH(Sheet1!A$5,Sheet1!$D$5:$J$5,0)))

 

[awoohaw]

@awoohaw - its a legacy Macro4 command. I think it only works if you put it in name manager.

@JOEE1979 - will this work for you ?

=GET.CELL(63,INDEX(Sheet1!$D7:$J7,1,MATCH(Sheet1!A$5,Sheet1!$D$5:$J$5,0)))

Thanks @Alex Blakenburg .

 

[JOEE1979]

@awoohaw - its a legacy Macro4 command. I think it only works if you put it in name manager.

@JOEE1979 - will this work for you ?

=GET.CELL(63,INDEX(Sheet1!$D7:$J7,1,MATCH(Sheet1!A$5,Sheet1!$D$5:$J$5,0)))

is this formula for a cell? if so, its not working

 

[Alex Blakenburg]

is this formula for a cell? if so, its not working

No in name manager.