Help needed with IF statement

[jnall1]

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!

[Special-K]

Try this

=2-ISNA(MATCH(G1,D$1:D$100,0))

or this

=IF(ISNA(MATCH(G1,D$1:D$100,0)),1,2)

and copy down the column

[ChemistB]

Assuming data starts in row 2
In H2,
=IF(ISNUMBER(MATCH(G2,$D$2:$D$10000,0)),1,2)
Does that work for you?

[jnall1]

Fantastic!!!! Thank you so much.

[Cutter]

@ jnall1. Welcome to the forum.

If you are satisfied with the solution(s) provided, please remember to mark your thread as Solved.

New quick method:
Select Thread Tools (above first post on page) -> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix".
Change to "Solved"
Click Save

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.