vlookup lookup_value

[rzml]

XLookup_Example_XelPlus.xlsx
	A	B	C	D	E	F	G	H
1	serial#	Student Name	Student ID No.	Assignment 1	Assignment 2	Assignment 3	Midterm Exam	Final Exam
2	1	Wilson, Wade	4438	#N/A
3	2	Warren, Miles	9701
4	3	Rogers, Steve	8187
5	4	Richards, Franklin	9605
6	5	Rasputin, Piotr	6795
7	6	Pym, Henry	2323
8	7	Olsen, Jake	4898
9	8	Myers, Fred	7650
10	9	Marko, Flint	8834
11	10	Marko, Cain	9912
12	11	Macendale, Jason Phillips	8423
13	12	Kingsley, Roderick	1682
14	13	Kasady, Cletus	8998
15	14	Jones, Angelica	3923
16	15	Hardy, Felicia	9474
17	16	Foswell, Frederic	2180
18	17	Essex, Nathanial	9680
19	18	Esks, Basil	7048
20	19	Dillon, Maxwell	9180
21	20	Creed, Victor	3985
22	21	Cassidy, Sean	4362
23	22	Blonsky, Emil	4692
24	23	Batroc, Georges	2586
25	24	Barton, Clinton Francis	2665
26	25	Baldwin, Robbie	7807
27	26	Astrovic, Vance	3956
Sheet2

Cell Formulas
Range	Formula
D2,C2:C27	D2	=VLOOKUP(C2,Sheet1!$A$3:$G$30,MATCH(D$1,Sheet1!$A$3:$G$3,0),0)
A2:A27	A2	=ROW()-1

hi guys,
Is there a better way to get the value of the cell based on the row and column header. I use vlookup and match but once I try to use the formulae in the adjacent cell N/A due to lookup_value, so I always have to change it to the correct row header.

 

[FormR]

Hi, don't you just need to lock the column reference.

=VLOOKUP($B2,Sheet1!$A$3:$G$30,MATCH(C$1,Sheet1!$A$3:$G$3,0),0)

 

[rzml]

Hi, don't you just need to lock the column reference.

=VLOOKUP($B2,Sheet1!$A$3:$G$30,MATCH(C$1,Sheet1!$A$3:$G$3,0),0)

oops, sorry for the stupid question for some reason I thought that won't work, but it did. Thanks