VLOOKUP

The VLOOKUP formula is used to search for a value in the first column of a range of cells and return a value in the same row from a specified column. To use the VLOOKUP formula, select the cell where you want the result to appear and enter “=VLOOKUP(” followed by the value you want to search for, the range of cells you want to search in, the column number of the value you want to return, and whether you want an exact match or an approximate match. For example, “=VLOOKUP(A1,A2:B5,2,FALSE)” would search for the value in cell A1 in the first column of cells A2 through B5, and return the value in the second column of the same row.

Example:

Search for the value in cell A1 in the first column of cells A2 through B5, and return the value in the second column of the same row: =VLOOKUP(A1,A2:B5,2,FALSE).