How to use Vlookup in Google Sheets
-
Loading... - Farish Danial
- 10 Feb 2023
- 64 Views
- 0 Like
- 0 Comment
VLOOKUP can save time in Google Sheets directories. Here's how to put it to use
The Google Sheets spreadsheet tool has plenty to praise: It’s free, friendly for Android devices, and is easily shareable for collaborative work. New users may be wondering just how similar it is to Excel – and the good news is that there are plenty of things in common, including certain technical tricks you may be used to. Sheets is basically a cloud-based, more robust web version of Excel. Though it is web-based.
That brings us to VLOOKUP, a very common function in Excel that’s used to parse large directories of data. VLOOKUP still works in Sheets, although it’s slightly different. Our guide will give you the basics to apply the formula to what you’re working on.
What is VLOOKUP, and why might you need it?
VLOOKUP is a valuable search function when you are handling a lot of directory-like data and need to quickly find specific data sets or organize it in a certain way. Google’s own diagram below uses the price and quantity of fruits as an example, but you can see how the formula can be applied to all kinds of complicated databases.
That includes employee directories with ID numbers, salaries, and other information, or databases of customers and students. Read More…
