Question: Referring to the Records table ( A 2 :E 1 1 ) below from which the Grade of the student is returned in cell B

Referring to the Records table (A2:E11) below from which the Grade of the student is returned in cell B14 according to the ID entered in cell B12. Which formula can be written in cell B14 and filled down to cell B17 to obtain appropriate search results?
\table[[,A,B,C,D,E],[1,ID,Age,Gender,Score (%),Grade],[2,F201,23,F,88,A],[3,W300,21,M,56,D+],[4,S008,20,F,78,B+],[5,S213,22,F,45,E],[6,S100,22,F,68,C+],[7,W301,30,F,90,A+],[8,W302,21,M,34,F],[9,F110,20,M,73,B],[10,W200,23,M,62,C],[11,,,,,],[12,Search,W301,,,],[13,Info,,,,],[14,Age,30,,,],[15,Gender,F,,,],[16,Score (%),90,,,],[17,Grade,At,,,],[12,,,,,]]
= VLOOKUP(B$14, $A$2 : $E$10, MATCH(A14, A$1:E$1,0),0)
= VLOOKUP , MATCH (A14,$A$2:$10,0),0
Referring to the Records table ( A 2 :E 1 1 )

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!