The classic VLOOKUP function in Google Sheets is arguably the most well known “advanced” spreadsheet formula. VLOOKUP is part of the serious spreadsheet users lingo. Knowing it signifies you have considerable spreadsheet chops and should be taken seriously. It’s not difficult to learn if you begin with the concept of the VLOOKUP before getting bogged … Continue reading VLOOKUP Function in Google Sheets
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: … Continue reading How To VLOOKUP To The Left In Google Sheets?
VLOOKUP with a single wildcard Imagine we have this table of employee information and we’ve been given a partial name (in this example: “Mye“) to find and retrieve information about. To do this we use a standard VLOOKUP formula with the wildcard asterisk character: *