Lookup Functions When you have spreadsheets with tons of data, finding just what you need can be daunting. Using Lookup functions can be a huge time-saver. For example, VLOOKUP searches vertically down the left-most column of a cell range to find a value specified. When it finds the value, it then looks across the row and returns the value in the column specified. VLOOKUP Click the cell where you want to add the VLOOKUP formula. Click Insert Function. Select Lookup & Reference from the list of categories. Select the VLOOKUP function. Click OK. Fill in the function arguments. Lookup_value: The number you want to search for in the left-most column. Table_array: The cell range you want to search in. Col_index_num: The column number for the value you want to look up. For this formula, each column has a number assigned. Column A=1, B=2, etc. Click OK. The formula is added and it returns the data for the lookup value. You can update the lookup value as needed to find the necessary information. Tip: The HLOOKUP function is similar to VLOOKUP, except it searches horizontally across the top row of cells until it finds the value specified. When it finds the specified value it looks down the column to find the specified value.
Lookup Functions When you have spreadsheets with tons of data, finding just what you need can be daunting. Using Lookup functions can be a huge time-saver. For example, VLOOKUP searches vertically down the left-most column of a cell range to find a value specified. When it finds the value, it then looks across the row and returns the value in the column specified. VLOOKUP Click the cell where you want to add the VLOOKUP formula. Click Insert Function. Select Lookup & Reference from the list of categories. Select the VLOOKUP function. Click OK. Fill in the function arguments. Lookup_value: The number you want to search for in the left-most column. Table_array: The cell range you want to search in. Col_index_num: The column number for the value you want to look up. For this formula, each column has a number assigned. Column A=1, B=2, etc. Click OK. The formula is added and it returns the data for the lookup value. You can update the lookup value as needed to find the necessary information. Tip: The HLOOKUP function is similar to VLOOKUP, except it searches horizontally across the top row of cells until it finds the value specified. When it finds the specified value it looks down the column to find the specified value.
Excel-2016-pt1.docx