How to use the notorious VLOOKUP function in Google Sheets?

How to use the notorious VLOOKUP function in Google Sheets?

And how to overcome the various challenges it poses. One of the most amazing (and confusing) function of Google Sheets (or Microsoft Excel) is VLOOKUP.

One of the most amazing (and confusing) function of Google Sheets (or Microsoft Excel) is VLOOKUP. Although not perfect in any sense of the word, it does provide powerful features to join two different tables, or append one table with the values of another.

What is VLOOKUP?

VLOOKUP is a function in spreadsheets which allows the user to establish a relationship between two tables. Let us try and understand it with an example.

Consider that you work as an analyst for an upcoming gaming studio and they want you to create a database of top selling game titles in the year 2002. Luckily for you, you found an amazing dataset with all the information and here is how it looks:

Image for post

It contains information in two separate tables:

  • One table consists the information about name of the game and the platform it is released on.
  • The second table contains the game title and it’s North American and European sales (in Millions).

For more information on the above dataset, you can visit Kaggle.

How do we combine the two tables? We can simply copy and paste the values from one to the other. But look closely, the names are not in the same order in the two tables! Well, we can always copy and paste one by one. But that’s too much task! Why don’t we ask the spreadsheets to do it for us? Sounds like a plan! And this is where the almighty VLOOKUP function comes up!

vlookup excel data-analysis analytics google-sheets function

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

How to send data from Google BigQuery to Google Sheets and Excel

How to send data from Google BigQuery to Google Sheets and Excel. Learn how to automatically and quickly send data from Google BigQuery to Google Sheets and Excel.

Exploratory Data Analysis is a significant part of Data Science

Data science is omnipresent to advanced statistical and machine learning methods. For whatever length of time that there is data to analyse, the need to investigate is obvious.

Automate Data Import to Google Analytics.

Automate Data Import to Google Analytics. Set up a data pipeline to import data to google analytics using Google Tentacles and GCP.

5 Essential Data Vs You Have to Take Care Of

Who starts good ends even better? I am pretty sure that on your data journey you came across some courses, videos, articles, maybe use cases where someone takes some data.

Getting Datasets for Data Analysis tasks — Advanced Google Search

In these articles, I’ll try to highlight some of the ways by which you can find data on the internet for free and then use it to create something meaningful out of it.