CHOOSECOLS is the function you need to use to extract data from the Shop and Tot columns, Sales is the name of the table containing the array, and [#ALL] tells Google Sheets that you want the ...

New to Google Sheets? This guide walks you through the basics of how to use Google Sheets, from creating a new sheet to entering and formatting data.

VLOOKUP, one of the most useful Microsoft Excel functions, is also available on Google Sheets. Here's how to use VLOOKUP to sift through Sheets data.