Explanation

This formula uses the value in cell F7 for a lookup value, the range B6:C10 for the lookup table, the number 2 to indicate “2nd column”, and zero as the last argument to force an exact match.

Although in this case we are mapping text values to numeric outputs, the same formula can handle text to text, or numbers to text.

VLOOKUP calculate grades

Get employee information with VLOOKUP

VLOOKUP two-way lookup

Merge tables with VLOOKUP

VLOOKUP without #N/A error

Sum text values like numbers

Map inputs to arbitrary values

VLOOKUP Function

The Excel VLOOKUP function is used to retrieve information from a table using a lookup value.

Excel formula: VLOOKUP calculate grades

The lookup values must appear in thefirstcolumn of the table, and the information to retrieve is specified bycolumn number.

VLOOKUP supports approximate and exact matching…

How to use VLOOKUP

Why VLOOKUP is better than nested IFs

How to replace nested IFs with VLOOKUP

How to use VLOOKUP for approximate matches

Excel formula: Get employee information with VLOOKUP

Excel formula: VLOOKUP two-way lookup

Excel formula: Merge tables with VLOOKUP

Excel formula: VLOOKUP without #N/A error

Excel formula: Sum text values like numbers

Excel formula: Map inputs to arbitrary values

Excel VLOOKUP function

Article image

Article image

Article image

Article image