INDEX(MATCH) returns #INVALID COLUMN VALUE
I have two sheets with a common "Name" column between them. I would like for a checkbox in the second sheet to reflect in the first sheet, factoring in that not all of the names will be used in the second sheet.
I would normally use INDEX(MATCH) for this purpose. MATCH() is able to return the row number for the Name where it appears in the other sheet (or an appropriate error for missing match), but INDEX(MATCH()) returns an error for the column containing checkboxes. I was expecting a 0 or 1 value depending on check status.
The INDEX reference is to the checkbox column on the other sheet. I have also tried VLOOKUP, but it returns the same #INVALID COLUMN VALUE error.
Does Smartsheet offer a better way to do this sort of lookup?
Help Article Resources
Check out the Formula Handbook template!