How to assign a name to a specific cell in a table?

[JenniferMurphy]

Is there a way to assign name to a specific cell in a table that will stay wsith that cell if the table is resorted?

I founbd some instructions on the web that said to select the cell and enter the name in the Name Box. But if I resort the table, the name does not follow the cell, it stays at the same relative physcial position in the table.

Thanks

 

[zero269]

Is there a way to assign name to a specific cell in a table that will stay wsith that cell if the table is resorted?

I founbd some instructions on the web that said to select the cell and enter the name in the Name Box. But if I resort the table, the name does not follow the cell, it stays at the same relative physcial position in the table.

Thanks

It sounds like you're talking about a Named Range. If so, YES, a single cell could serve as a Named Range and will not move if you use an absolute reference.

Here I created two tests:

Column A is a standard range where I Named $A$7 as lstNamedCell and holds value #667.
Column C is a Table where I Named $C$7 as tblNamedCell and holds value #667 as well.

Here I sorted each column in ascending order. Although the values #667 moved from Row 6 to Row 7, the Named Cells are still $A$7 and $C$7 respectively and now hold value #650.

 

[JenniferMurphy]

I think I wasn't clear. Let me try again.

Here is a table with some names, dates of birth, and ages. It is sorted by name. On the right, I added 3 ways to access Rosa's date of birth. They all get the correct answer as the table is currently sorted.

Family Database.xlsx
	C	D	E	F	G	H
5	Name	DoB	Age		Name	DoB
6	Amelia	7/02/1937	85.6		Rosa	12/01/1955
7	Dwight	6/06/1944	78.7		Rosa	12/01/1955
8	Franklin	12/07/1941	81.2		Rosa	12/01/1955
9	Gloria	12/15/1971	51.1
10	John	10/16/1962	60.3
11	Robert	8/06/1945	77.5
12	Rosa	12/01/1955	67.2
MrExcel

Cell Formulas
Range	Formula
H6	H6	=$D$12
H7	H7	=D12
H8	H8	=XLOOKUP(G8,TblTest[Name],TblTest[DoB])
E6:E12	E6	=CONVERT(TODAY()-[@DoB],"day","yr")

Now I resort the table by date of birth (or age). The first 2 now have the wrong answer. Only the third one tracks correctly. So that's the solution I was looking for.

Family Database.xlsx
	C	D	E	F	G	H
5	Name	DoB	Age		Name	DoB
6	Gloria	12/15/1971	51.1		Rosa	7/02/1937
7	John	10/16/1962	60.3		Rosa	7/02/1937
8	Rosa	12/01/1955	67.2		Rosa	12/01/1955
9	Robert	8/06/1945	77.5
10	Dwight	6/06/1944	78.7
11	Franklin	12/07/1941	81.2
12	Amelia	7/02/1937	85.6
MrExcel

Cell Formulas
Range	Formula
H6	H6	=$D$12
H7	H7	=D12
H8	H8	=XLOOKUP(G8,TblTest[Name],TblTest[DoB])
E6:E12	E6	=CONVERT(TODAY()-[@DoB],"day","yr")

I guess I was hoping for something like =TblTest[DoB[Name="Rosa"]].

Comments?