--- title: Retail | VLOOKUP Function Guide description: 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 --- [Skip to content](https://support.blaze.me/hc/en-us/articles/retail-vlookup-function-guide#main-content) [![BLAZE-Logo-Blue (2)](https://support.blaze.me/hs-fs/hubfs/BLAZE-Logo-Blue%20(2).png?width=140&height=37&name=BLAZE-Logo-Blue%20(2).png)](https://support.blaze.me?hsLang=en) - [BLAZE US Knowledge Base](https://support.blaze.me/hc/en-us/articles) Open main navigation Close main navigation - [BLAZE US Knowledge Base](https://support.blaze.me/hc/en-us/articles) Welcome to the Blaze US Knowledge Base! Find helpful reference by searching here... - There are no suggestions because the search field is empty. 1. [BLAZE US Knowledge Center](https://support.blaze.me/hc/en-us/articles?hsLang=en) 2. [BLAZE Retail](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en) 3. [Reporting](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#reporting) # 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)](https://support.google.com/docs/answer/3093318?hl=en) - [BLAZE Retail](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#main-content) - [FAQs](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#faqs) - [Ecommerce](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#ecommerce) - [Transactions](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#transactions) - [Loyalty / Marketing](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#loyalty-marketing) - [Members](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#members) - [Integrations](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#integrations) - [Reporting](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#reporting) - [Metrc](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#metrc) - [Delivery & Dispatch](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#delivery-dispatch) - [Getting Started](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#getting-started) - [BioTrack](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#biotrack) - [Promotions](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#promotions) - [Point of Sale (POS)](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#point-of-sale-pos) - [Purchase Orders](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#purchase-orders) - [Insights](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#insights) - [BLAZEPAY](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#blazepay) - [Compliance & Taxes](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#compliance-taxes) - [Inventory Management](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#inventory-management) - [Hardware & Labels](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#hardware-labels) - [Web POS App](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#web-pos-app) - [State Limits](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#state-limits) - [New Mexico S2S](https://support.blaze.me/hc/en-us/articles/blaze-retail?hsLang=en#new-mexico-s2s) - [BLAZE ECOM](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#main-content) - [ECOM Mission Control](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#ecom-mission-control) - [Ecommerce](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#ecommerce) - [Onboarding](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#onboarding) - [Website Content](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#website-content) - [Mobile Apps](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#mobile-apps) - [SEO](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#seo) - [General](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#general) - [Promotions, Discounts & Rewards](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#promotions-discounts-rewards) - [Integrations](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#integrations) - [WordPress](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#wordpress) - [Order Notifications](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#order-notifications) - [Online Store Configuration](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#online-store-configuration) - [Customization](https://support.blaze.me/hc/en-us/articles/blaze-ecom?hsLang=en#customization) - [BLAZEPAY](https://support.blaze.me/hc/en-us/articles/blazepay?hsLang=en#main-content) - [Cashless ATM](https://support.blaze.me/hc/en-us/articles/blazepay?hsLang=en#cashless-atm) - [BLAZE Growth](https://support.blaze.me/hc/en-us/articles/blaze-growth?hsLang=en) - [Ecommerce](https://support.blaze.me/hc/en-us/articles/ecommerce?hsLang=en#main-content) - [Online Store Configuration](https://support.blaze.me/hc/en-us/articles/ecommerce?hsLang=en#online-store-configuration) - [Mobile Apps](https://support.blaze.me/hc/en-us/articles/mobile-apps?hsLang=en#main-content) - [Go To Market](https://support.blaze.me/hc/en-us/articles/mobile-apps?hsLang=en#go-to-market) - [Troubleshooting](https://support.blaze.me/hc/en-us/articles/mobile-apps?hsLang=en#troubleshooting) - [Push notifications](https://support.blaze.me/hc/en-us/articles/mobile-apps?hsLang=en#push-notifications) - [Onboarding](https://support.blaze.me/hc/en-us/articles/mobile-apps?hsLang=en#onboarding) - [Payment Integrations](https://support.blaze.me/hc/en-us/articles/payment-integrations?hsLang=en#main-content) - [Birchmount](https://support.blaze.me/hc/en-us/articles/payment-integrations?hsLang=en#birchmount) - [BLAZE Sites](https://support.blaze.me/hc/en-us/articles/blaze-sites?hsLang=en#main-content) - [SEO](https://support.blaze.me/hc/en-us/articles/blaze-sites?hsLang=en#seo) - [General](https://support.blaze.me/hc/en-us/articles/blaze-sites?hsLang=en#general) - [Widgets](https://support.blaze.me/hc/en-us/articles/blaze-sites?hsLang=en#widgets) - [BLAZE Widgets](https://support.blaze.me/hc/en-us/articles/blaze-sites?hsLang=en#blaze-widgets) - [3rd Party Apps](https://support.blaze.me/hc/en-us/articles/blaze-sites?hsLang=en#3rd-party-apps) - [Company Products](https://support.blaze.me/hc/en-us/articles/company-products?hsLang=en) - [SSO(Single Sign-On)](https://support.blaze.me/hc/en-us/articles/ssosingle-sign-on?hsLang=en) - [BLAZE Brands](https://support.blaze.me/hc/en-us/articles/blaze-brands?hsLang=en) - [Product Catalog](https://support.blaze.me/hc/en-us/articles/product-catalog?hsLang=en) - [Compliance](https://support.blaze.me/hc/en-us/articles/compliance?hsLang=en#main-content) - [New Mexico](https://support.blaze.me/hc/en-us/articles/compliance?hsLang=en#new-mexico) [![BLAZE-Logo-Blue (2)](https://support.blaze.me/hs-fs/hubfs/BLAZE-Logo-Blue%20(2).png?width=140&height=37&name=BLAZE-Logo-Blue%20(2).png "BLAZE-Logo-Blue (2)")](http://blaze.me) BLAZE US Help Center Copyright © 2026, BLAZE Solutions Inc.