VLOOKUP Function VideosStep-by-step videos for Excel VLOOKUP function. Find product price in lookup table, or change student score numbers to letter grades. |
Find Product Price with VLOOKUPWatch 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 GradesIn 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. |
Last updated: July 5, 2022 3:11 PM