How Do I Use VLOOKUP in Google Sheets - EXACT Match

Опубликовано: 17 Декабрь 2024
на канале: SmallBusinessCOO
41
0

Come with us on this quick journey to discover the most common way to use VLOOKUP in Google Sheets to find exact matches and return a result from a related cell in a column.

Go here to get your copy of the Google Sheets: https://www.smallbusinesscoo.com/cont...

To learn other ways to use VLOOKUP and take your Google Sheets skills to the next level watch this video:    • How VLOOKUP Can Help Find Data Fast i...  

How do I use VLOOKUP in Google Sheets?

On the first sheet titled Inventory we have a list of inventory with Part, Description, Color, Quantity, Cost, and Total Value. Here I want to use VLOOKUP to key in the part number and return the quantity in inventory. So, I’m going to type in the word “Hoodie” in cell A5 because I want to return the number of hoodies in stock for quick reference. You can see where this would be helpful when there are 100s of inventory items in a list. In Cell B2 I am going to create the VLOOKUP formula to return the correct quantity. Are you ready with your copy of this workbook? Type in =vlookup( and you will see a formula popup. Here you will notice the elements of the formula include search key, range, index, and is sorted. The search key is the item you want to find. In our case it’s the hoodie. The range is the table we want to search or the inventory list. The index is the column you want to return. So, in our data we have columns D-I. D is column 1, E is column 2, then 3,4,5, and 6 is column I. So, we want our index to be 4 to pull the quantity. The final element “is_sorted” basically is asking whether the first column in your range is sorted or not. Generally this will be False, but sometimes you can choose true. If you click on the box you can see more information from google regarding this formula. But, let’s finish the formula and see how it works. Starting with =vlookup( type in a5,d5:i12,4,false) and let’s see what we get. Here you can discover that the formula returned 5 hoodies in inventory.

music by creatormix.com