Vlookup function in Excel

Use VLOOKUP when you need to find things in a table or a range by row and column. For example, find a students name based on their student ID (Unique Identifier).