VLOOKUP Function in Google Sheets

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 Vlookup Return Multiple Columns in Google Sheets

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

How To VLOOKUP To The Left 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 In Google Sheets Using Wildcards For Partial Matches

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: *