Contextures

VLOOKUP Function Videos

Step-by-step videos for Excel VLOOKUP function. Find product price in lookup table, or change student score numbers to letter grades.

order form with VLOOKUP formula

Find Product Price with VLOOKUP

Watch this short video, to see how to make a VLOOKUP formula, to find a product price. The written steps are below the video.

For written steps, and the sample file, go to the Excel VLOOKUP page.

Change Student Scores to Letter Grades

In some situations, an approximate match is preferred, so several values will return the same result. For example, this lookup table shows the minimum score for each letter grade, and VLOOKUP returns the correct letter grad for each score number.

For written steps, and the sample file, go to the Excel VLOOKUP page.

More Video Training

Drop Down List (Basic) Videos

Dependent Drop Down Videos

Data Entry Videos

Pivot Table Videos

 

Last updated: July 5, 2022 3:11 PM