Retail | VLOOKUP Function Guide

VLOOKUP

Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.

In this article, we will be going over of an example of how to use the Vlookup function to grab the member e-mail addresses from the member export, and get them onto the same sheet as the Total Sales Detail report (TSDR) or the Total Sales report (TSR)

Steps: 

  1. Upload the spreadsheet(s) to google sheets
  2. Move the "member ID" Column to column A position by dragging and dropping it
  3. create a new blank column by right clicking column B and selecting "insert 1 left"
  4. Insert the vlookup function into B2 =vlookup(A2,A:S,2 (the video example used 18),false)  Once you have the function up, you can click the cell "A2" to insert it into the function, and after the comma, select the range of columns you want to include.
  5. Fill the function into column B by double clicking the bottom right of Cell B2 to auto fill the function down the whole column

Video Guide:


Syntax

VLOOKUP(search_key, range, index, [is_sorted])

  • search_key - The value to search for. For example A2. This is the cell you will click after starting the =vlookup() function.

  • range - The range to consider for the search. The first column in the range is searched for the key specified in search_key. The range looks at the range of columns to consider for returning values

  • index - The column index of the value to be returned, where the first column in range is numbered 1. Example would be if you wanted the vlookup function to return the value in the 3rd column, you would put "3" here for the index.

    • NOTE: If index is not between 1 and the number of columns in range, #VALUE! is returned.
  • is_sorted - Use the word "true" or "false" here. False is recommended, it means it will search for an exact match of the value being referenced.


    References:
    Google Helpdesk article:
     VLOOKUP - Docs Editors Help (google.com)