I wanted to show you a formula that is super useful in Google sheets, you might discover it or maybe just want to refresh your memory because we tend to forget this one if we don’t use it too often:
You’ll see how easy it is, just click on this 1-minute video, it much easier to understand this way than reading any explanation, trust me:
Here I'm gonna show you how to use the VLOOKUP. You'll see, it's super simple.
So, we have a table where we have two tabs:
1. The first one is the ORDERS, where I have a column with the ID and then other information like the city
2. Then, I have another tab with the REVENUES where I also have the ID and some other information.
In the REVENUES tab, I want to add the city from the ORDERS tab.
So, what I'm gonna do is that I'm gonna use VLOOKUP in the REVENUES tab.
I type =VLOOKUP and here I have to add some arguments:
1. The first argument is the common element between the two tables: my ID here.
2. As a second argument, I have to select the whole table from the other tab, ORDERS.
3. The third argument is the index. The index is simply the rank at which is the information I want from that table. Here I want the city, which is in the 3rd column, so I'll type 3. That's it.
4. At last, just please believe for now, write FALSE. Later on, when you'll master the VLOOKUP, you'll try it with TRUE for certain use cases.
You want to use the VLOOKUP for your whole table so you just add dollars in front of the letters and the numbers. Pro tip: to lock cells, there’s a shortcut: F4 on Windows, fn + F4 on Mac.
Last, you copy the cell and paste it to the whole column cells and boom, here it works!
Enjoy your new skills 😉