I have one table with item names in the first column, and I want to add a column that displays TRUE if the item name is present in the first column of another table of item names.
In Excel I would do this with a VLOOKUP or MATCH wrapped in an IFERROR...
actually, I think my requirement of “pasting in a new list in table B at any time” will prevent that solution, because I don’t want to be re-linking everything each time.
Basically I want to check whether a list of item names in one table A is a subset of item names in another table B, but I don’t want the items in table A to just be lookup values from table B because I want to be able to delete and paste a new update...
