Hello. I have 2 tables, each with a list of names and email addresses and other information. I am trying to link the tables such that table A will search for the same email address in Table B and then pull a related column from Table B into Table A....

I am trying to fill a filtered column with the same text value, but the table is filtered on the same column as ‘empty’. When I add the text to the first row/cell, the row then disappears because the cell is no longer empty. Then I have no way of a...