How to Use Vlookup in Google Sheets | Scribe

    How to Use Vlookup in Google Sheets

    • Alai Umerez |
    • 8 steps |
    • 31 seconds
      1
      Choose the cell where you want to apply the Vlookup formula
      information ordinal icon
      Vlookup Formula Syntax: =VLOOKUP(search_key, range, index, \[is_sorted\])
      2
      **Vlookup**\ Type "=vlookup" and select the "Vertical lookup" option from the drop-down menu
      3
      **Search_Key** Select the value to look for in the first column of the range
      4
      **Range** Select the range of the data table. In this case, the information of the table is written from the cell B4 all the way to the cell D8)
      5
      **Index** The number of the column within the specified range that contains the return value. It must be a positive integer. In this case, we want to take the information from the third column of our table, hence, we type "3"
      6
      **\[is_sorted\]** Type "FALSE" to ensure an exact match (recommended) or "TRUE" for an approximate match (this is the default if is_sorted is unspecified)
      7
      Once the formula is ready, complete it by using a closing parenthesis
      8
      Press "enter" and review the results of your vlookup