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