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