DVARP - Google Drive

DVARP : Student Grade


1	Database_arr
2	Key	Student ID	Class	Grade
3	1	N1707	2012	85
4	2	N1327	2013	87
5	3	N1890	2012	79
6	4	N1122	2012	78
7	5	N1357	2013	81
8	6	N1652	2012	89
9	7	N7475	2013	92
10	8	N1314	2012	90
11
12
13	Criteria_arr
14	Key	Student ID	Class	Grade
15			2012
16
17	Result	Formula
18	24.56	=DVARP($A$2:$D$10, "Grade", $A$14:$D$15)
19	24.56	=DVARP($A$2:$D$10, D2, $A$14:$D$15)
20	24.56	=DVARP($A$2:$D$10, 4, $A$14:$D$15)
21	24.56	=DVARP('Student Grade'!$A$2:$D$10, "Grade", $A$14:$D$15)
22

Published by Google Sheets–Report Abuse–Updated automatically every 5 minutes