Apr 17 2021 09:23 PM - edited Apr 17 2021 09:35 PM
Hi,
I have here sheet 1 and 2. I want to know if an email matches that email from a column of a different google sheet file. I have created here sample sheets. I want the result (column 2) of the first sheet to show, if the email in column 1 can be found in the column 1 of sheet 2. So the result will then show that, that email in sheet one is TRUE from sheet 2.
Sheet 1:
https://docs.google.com/spreadsheets/d/1hiboPpCKBQ8qgFmnahQUxt5Lva5uNOSYt9Oq7p57-7Y/edit?usp=sharing
Sheet 2:
https://docs.google.com/spreadsheets/d/1u0I5iB0hCfP_DZNCuQ-_fnbL3EAVJuXZkjLJ3aS_HPM/edit?usp=sharing
I really hope someone can help me. Been working on this for 8 days now.