Vlookup

VLOOKUP is a powerful Excel function that allows you to look for a specified value in one column of data inside a table, and then fetch a value from another column in the same row.

Basically, VLOOKUP lets you search for specific information in your spreadsheet. For example, if you have a list of products with prices, you could search for the price of a specific item.

1.Create your spreadsheet. You must have at least two columns of information for Vlookup to work, but you can have as many as you need.

2.In a blank cell type the Vlookup formula. In the cell, enter this formula: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup).

You can use any cell to write this is, but remember that whatever cell you choose is entered as the “lookup value” in your function code.