Review Of How To Use The Vlookup Function References. The syntax and arguments are =vlookup ( search_value , lookup_table , column_number, [ approximate_match] ) this article explains how to use the vlookup function in all versions of excel, including excel 2019 and microsoft 365. The value 4 (third argument) tells the vlookup function to return the value in the same.

For example, you can look up the price of a product in a database or find an employee’s name based on their employee id. Web the basics of using vlookup. (h2,b3:f25, enter column index number.