How to Use VLOOKUP in Microsoft Excel (Free PDF Guide Inside)

Microsoft Excel vlookup function

What is VLOOKUP function? You can use the VLOOKUP function to search the first column of a range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells, and then return a value from any cell on the same row of the range. For example, suppose that you have a list of employees contained in the range A2:C10. The employees’ ID numbers are stored in the first column of the range. See example below. If you know the employee’s ID…

Read More