Category: Spreadsheets

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).

Return multiple values with single vlookup formula in Google Sheets

Of course, you could set up multiple vlookup formulas, but this wouldn’t work if you want to pass the data range into another formula, like the sparkline for example.

However, you can easily achieve it with just one formula.

Continue reading Have Vlookup Return Multiple Columns in Google Sheets

How To Zoom In And How To Zoom Out In Google Sheets

Google Sheets Zoom

Under the menu View > Zoom you can control the zoom level of your Sheet, from 50% up to 200%:

zoom in google sheets

There are no shortcut keys to zoom in or zoom out in Google Sheets.

Browser Zoom

You also have the option to zoom in or out with your browser:

Browser zoom in Google Sheets

In Google Chrome, try the following menu options in your Browser menu:

View > Zoom In
View > Zoom Out

or use the shortcuts on a PC:

Ctrl and +
Ctrl and -

or on a Mac:

⌘ and +
⌘ and -

In the main bar of your browser, on the right side next to the bookmark star, you’ll see a magnifying glass and an indication of what zoom level you’re at (see the image above). There’s also a quick option to Reset back to 100% zoom level.

Zoom status in Google Chrome browser

Pro tip:

To quickly enter full-screen mode on a PC, press:

F11

or, on a Mac, press:

⌘ and Ctrl and F

Press these same shortcuts again to exit full-screen mode.

See Also

How to use Google Sheets: A Beginner’s Guide

How To Make a Table in Google Sheets, and Make It Look Great

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:

Vlookup to the left

Continue reading How To VLOOKUP To The Left In Google Sheets?

How To Add A Hyperlinked Index Sheet In Google Sheets

Admit it, we’ve all been there. Getting frustrated trying to find a specific sheet inside a huge workbook, and not being able to see it amongst all the other sheets.

Well, here’s a quick Apps Script to create a hyperlinked index page at the start of your workbook. Continue reading How To Add A Hyperlinked Index Sheet In Google Sheets

Funnel charts in Google Sheets using the chart tool, formulas and Apps Script

Let’s talk about funnel charts in Google Sheets.

The charts themselves are a bit of a novelty. Yes, they’re aesthetically pleasing because of that resemblance to a real-world, tapering funnel, which reinforces their message, but a plain ole’ bar chart would be equally suitable and actually easier to read data from (because the bars have a common baseline).

However, they throw up some interesting techniques in Google Sheets and for that reason, merit this long article.

We’ll build them using tricks with the chart builder tool, then with two different types of funky formula and finally, and best of all, we’ll build a tool using Apps Script, as shown in this image:

Funnel charts with apps script in Google Sheets

Continue reading Funnel charts in Google Sheets using the chart tool, formulas and Apps Script