How to INDEX multiple columns

I needed to check multiple columns in different spreadsheets and output the matching result. I wasn’t sure that VLOOKUP would work for this case and INDEX-MATCH is supposed to be better anyway, so I used the following code. It uses IFERROR to nest MATCH functions: The above checks for matches in colums A, Q, and P in SpreadsheetA, and columns…

Continue Reading

How to SORT multiple columns in Google Sheets

Yesterday I was working on a spreadsheet that needed to SORT items from several different columns. SORT only accepts one argument, and I couldn’t find any examples online about how (or if) you could SORT multiple columns. Maybe this is obvious to everyone else, but it wasn’t to me. The answer is to put arguments within an array like this…

Continue Reading