The range of cells in which the VLOOKUP will search for the lookup_value and the return value. Lookup_value can be a value or a reference to a cell. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument.įor example, if table-array spans cells B2:D7, then your lookup_value must be in column B. VLOOKUP (lookup_value, table_array, col_index_num, ) Use the VLOOKUP function to look up a value in a table. Tip: The secret to VLOOKUP is to organize your data so that the value you look up (Fruit) is to the left of the return value (Amount) you want to find. =VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
In its simplest form, the VLOOKUP function says: Tip: Check out these YouTube videos from Microsoft Creators for more help with VLOOKUP! For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. Use VLOOKUP when you need to find things in a table or a range by row. Tip: Try using the new XLOOKUP function, an improved version of VLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use than its predecessor.
0 kommentar(er)
