The VLOOKUP function in Google Sheets is a vertical lookup function. You use it to search for an item in a column and return data from that row if a match is found. In the following example, we use a VLOOKUP formula to search for “Charles Dickens” in column 1. When we find it, the … Continue reading VLOOKUP Function in Google Sheets: The Essential Guide
Have you ever wanted use the VLOOKUP function with multiple criteria? For example, you may want to use first name and last name combined to search for a value using Vlookup. In this post, you’ll see how to Vlookup multiple criteria in Google Sheets, with three different scenarios.
Have you ever wished the VLOOKUP function could return multiple columns? For example, maybe you want to return several values that match a search term so that you can use a range of data as an input for another formula (e.g. a sparkline). Of course, you could set up multiple vlookup formulas, but this wouldn’t … Continue reading Have Vlookup Return Multiple Columns in Google Sheets
The VLOOKUP function is a super popular formula but suffers from a major drawback. You can’t lookup data to the left! However, there’s a sneaky trick that lets us VLOOKUP to the left, so we can search for a term and return a result from a column to the left of the original search column:
In this post, you’ll learn how to use the VLOOKUP With Wildcard in Google Sheets.
