Using the VLOOKUP function with an exact match and the student data table in the

Question

Using the VLOOKUP function with an exact match and the student data table in the range A22:K57, retrieve the first name, last name, weighted average, and class rank for studnet 14858 in the range B9:B12. Use an absoulte reference to the lookup talbe. Note that the first name is found in the third column of the studnet data table, the last name is found in the secound column, the weighted average is found in the tenth column, and the class rankis found in the eleventh column.

Not really sure how to use VLOOKUP.

Explanation / Answer

ANSWER:

student ID =14858

first name= Albertine

last name= Wilson

Weighted Average=94.4

Class Rank = 4

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.