Look up Data

[mayhem]

Dear Chandoo

Please forgive me if the title is not accurate.

I am a fairly basic user of Excel and have just started a role that requires much reporting.

I have an email exclusion list and would like to know the best formula to search current data to exclude the emails from my list.

I have uploaded a basic example of the 2 sheets I wish to compare and return the text "Include" or "Exclude" in another column. As I'm not certain which formulas require sorting of data, it might be better to assume that I cannot sort data. Again please forgive me if there is already a post relating to something similar.

Many thanks for your help,
M

 

[SirJB7]

Hi, Mayhem!

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, try this in cell B2 and copy down as required:
=SI(ESNOD(BUSCARV(A2;Exclude!A:A;1;FALSO));"Include";"Exclude") -----> in english: =IF(ISNA(VLOOKUP(A2,Exclude!A:A,1,FALSE)),"Include","Exclude")

Regards!

 

[mayhem]

Dear SirJB7

Thank you so much for the quick response, your Ninja skills are swift and most helpful. Have a good day

p.s. What language is the initial string if not English?

 

[SirJB7]

Hi, mayhem!
Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.
Regards!
PS: I use a Spanish Excel version so I always copy the original formulas as I write them, and then I post the English version, sometimes overwriting, others from the immediate window pane via the Debug.Print Activecell.Formula, so for avoiding typo errors I always keep posted the original ones as I don't save them all.