Please HELP

%3CLINGO-SUB%20id%3D%22lingo-sub-2277086%22%20slang%3D%22en-US%22%3EPlease%20HELP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277086%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20saviors%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20count%20the%20an%20email%20that%20is%20in%20a%20column%20of%20one%20google%20sheet%2C%20and%20see%20if%20it%20matches%20another%20email%20in%20another%20column%20of%20another%20spreadsheet.%20I've%20tried%20so%20many%20formulas%20I%20just%20can't%20get%20it%20right%20so%20it's%20like%20this%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20many%20columns%2C%20then%20in%20column%20C%20is%20the%20emails.%20This%20is%20in%20a%20completely%20different%20google%20sheet%20file.%20What%20I%20want%20to%20is%20to%20count%20the%20matching%20emails%20from%20this%20column%20to%20another%20column%20of%20another%20different%20google%20sheet%2C%20and%20that%20the%20emails%20that%20matches%20should%20turn%20out%20as%20named%3A%20%22Applied%22%20or%20just%201%20or%20TRUE%20or%20whatever%2C%20and%20this%20result%20will%20show%20in%20another%20column%20of%20the%20same%20first%20spreadsheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2277086%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2277098%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20HELP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277098%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1029386%22%20target%3D%22_blank%22%3E%40elevenwinds11%3C%2FA%3E%26nbsp%3BMost%20likely%2C%20the%20lack%20of%20response%20is%20due%20to%20the%20fact%20that%20the%20question%20relates%20to%20Google%20Sheets.%20This%20forum%20deals%20with%20MS%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2277088%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20HELP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277088%22%20slang%3D%22en-US%22%3EAny%20help%20so%20far%3F%20Please%20let%20me%20know%20if%20you%20needed%20the%20visuals%2C%20huhu%3C%2FLINGO-BODY%3E
New Contributor

Dear saviors, 

 

I am trying to count the an email that is in a column of one google sheet, and see if it matches another email in another column of another spreadsheet. I've tried so many formulas I just can't get it right so it's like this: 

 

I have a spreadsheet with many columns, then in column C is the emails. This is in a completely different google sheet file. What I want to is to count the matching emails from this column to another column of another different google sheet, and that the emails that matches should turn out as named: "Applied" or just 1 or TRUE or whatever, and this result will show in another column of the same first spreadsheet. 

 

Please help.

2 Replies
Any help so far? Please let me know if you needed the visuals, huhu

@elevenwinds11 Most likely, the lack of response is due to the fact that the question relates to Google Sheets. This forum deals with MS Excel.