Hlookup and structured references

[Sean M]

Hello,

I am a college student learning how to use Excel. I am having trouble with doing structured references in a Hlookup function in Excel. In the minisheet below, I am supposed to put a Hlookup function in E2 that looks up the value in the range P13:U14 in the 2nd row. The value I am supposed to use should be put as an absolute reference and as a structured reference. I am also supposed to find an approximate match. The online software that I am using will count off if I don't have that specific function. Can anyone help me?

Thank you,

Sean M

NP_EX19_7a_SeanMevis_2.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Student ID	Name	Age	Post-Secondary Years	Base Rate	Class	Finance Certified	Grad Student	Elected	Qualified Driver	Leadership Training	Mentor	Officer Qualified	Column1
2	G62918	Kay Colbert	24	6		2022	Yes	Yes	No							Student ID	G62918
3	P49234	Michael Crozier	25	7		2023	Yes	Yes	Yes							Student Name	Kay Colbert
4	W99035	Brandon Miles	21	3		2022	Yes	No	Yes
5	V42056	Michael Alvarez	22	4		2023	Yes	No	No
6	T59828	Ida Smith	19	2		2024	No	No	Yes
7	F72412	Betty Garza	24	6		2025	Yes	Yes	No								Total Students	Average Post-Secondary Years
8	W20999	Leroy Pirkle	28	10		2022	Yes	Yes	No							Elected Students
9	Q18870	Warren Stewart	18	0		2026	No	No	No							All Students	30
10	W75774	Stacy Wiggins	24	6		2025	Yes	Yes	Yes
11	N25220	Billy Herald	21	3		2022	No	No	No
12	O94361	Margaret Cruz	23	5		2023	Yes	No	No
13	G87578	Chester Keese	18	0		2024	No	No	No							Postsecondary Years	0	1	2	5	8
14	B68170	Claudette Littell	19	1		2026	Yes	No	No							Base Rate	15	15.25	15.75	16.5	17.5
15	M89375	Florence Miller	21	3		2023	Yes	No	No
16	S63900	Kimberly Gerace	26	8		2023	Yes	Yes	No
17	Y96036	Roman Goble	22	4		2025	Yes	No	No
18	C82505	Jocelyn Allen	22	4		2022	Yes	No	Yes
19	Y75358	Ron Morse	20	2		2022	Yes	No	No
20	J60811	Roberta Ervin	21	3		2026	No	No	No
21	Q56783	James Rusnak	19	1		2022	Yes	No	Yes
22	Q75281	Suzanne Lawrence	24	2		2025	Yes	No	Yes
23	V73596	Shannon Garner	18	0		2024	No	No	No
24	L86947	Emory Little	25	5		2023	Yes	Yes	Yes
25	W90960	Laura L i	24	6		2022	Yes	Yes	Yes
26	P40886	Floretta Cauthen	18	0		2025	No	No	No
27	U88627	Beverly Berry	23	5		2023	Yes	No	No
28	Y88831	Stephanie Papa	19	1		2023	Yes	No	Yes
29	P83373	Wallace Rivera	29	9		2023	Yes	Yes	No
30	B53454	Larry Russell	19	1		2022	No	No	No
31	A60088	Aaron Sifford	25	7		2023	Yes	Yes	Yes
Student Representatives

Cell Formulas
Range	Formula
Q3	Q3	=VLOOKUP(Q2,StudentRepresentatives[[Student ID]:[Name]],2,FALSE)
Q9	Q9	=COUNTA(StudentRepresentatives[Elected])

Cells with Data Validation
Cell	Allow	Criteria
A1:U31	Any value

 

[Fluff]

Hi & welcome to MrExcel.
What have you tried?

 

[Sean M]

I was working on the hlookup function, but I realized I didn't know how to do structured references when I am getting information from a different table on the same worksheet. The second table that I am refering to is the range P13:U14. As far as I know it is not named. Any ideas? I hope I am phrasing this in a way that you understand.

 

[Fluff]

If it doesn't have a name then it's not a table & you cannot use structured references.