Creating One-way VLOOKUP in Excel | Lookup a name, or a score from a large dataset in Excel

This tutorial walks you through the fundamentals of VLOOKUP before delving into examples of how to use it for assessing students grades in an exam. Perfect for teachers, educators, and marketers who want to keep other details in the table private while revealing the value of a certain item!

The formula employed in this video is:
=VLOOKUP(G2, A2:D28, 2, FALSE) For looking up the chemistry score in col. 2.
=VLOOKUP(G2, A2:D28, 3, FALSE) For looking up Physics score in col 3
=VLOOKUP(G2, A2:D28, 4, FALSE) For looking up Math score in col 4

G2 is the cell used to enter each student name.
A2:D28 is the table array.

I will love to know your thoughts about this video. Please drop a comment.

Don't forget to SUBSCRIBE, LIKE & SHARE.

#vlookup #excel #exceltutorial #exceltips #datascience #dataanalysis