Searches down the first column of a range for a key and returns the value of a specified cell in the row found.
VLOOKUP(search_key, range, index, [is_sorted])
Use FALSE for exact match. Consider switching to INDEX-MATCH for more flexibility.
Need expert help? →