I have a column of unique text names in column D. I also have a column of names in column G (that are unique in column G but may also show in column D). In column H, I'd like to create a function that searches column D and compares the names in column G -- returning a '2' if it shows in D and a 1 if it does not.

I've tried a few If statements but I'm assuming it's not working because the columns do not equal the text, it contains the text....

Please help...

Thanks!