David_Andreae - profile

David_Andreae · Nov 23, 2018

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...

David_Andreae · Nov 23, 2018

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.

David_Andreae · Nov 23, 2018

thanks Kamille, it sounds a rather indirect way of doing it, but I will give it a go!

David_Andreae · Nov 23, 2018

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...

User Statistics

User Activity

Column to check existence of cell value in another table

Re: Column to check existence of cell value in another table

Re: Column to check existence of cell value in another table

Re: Column to check existence of cell value in another table