If value contains x number from list print found if not print N

[icomefromchaos]

I am trying to see if a certain text is contained in a list. My next that I want to search over and see if it contains a value in a list is in column E and the list is located in column G. In column F i want to print Found if the number from G was found in E. Below is the formula that I used....
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: inherit;"> IF(ISNUMBER(MATCH(G2:G118, E2:E4612, 0)), "N", "FOUND")
</code>It seems that everything worked just fine, until I was reviewing the matches and further down the column there is this series of number. The formula found only 1 in a set that was in column G...
66618 N
66618 N
66618 FOUND
66618 N
66618 N
ANND further down the sheet. it seems that the formula stopped running and marked all of the numbers as Found, even when they were not in column G.
Would anyone happen to have any suggestions?

 

[Jonmo1]

The first reference (column G) needs to be just a single cell, not the whole range.
And the 2nd range (column E) needs to have the rows absolute.
And you have the N and FOUND backwards.


Try
IF(ISNUMBER(MATCH(G2, E$2:E$4612, 0)), "FOUND", "N")

 

[icomefromchaos]

The first reference (column G) needs to be just a single cell, not the whole range.
And the 2nd range (column E) needs to have the rows absolute.
And you have the N and FOUND backwards.


Try
IF(ISNUMBER(MATCH(G2, E$2:E$4612, 0)), "FOUND", "N")

I have over 500 items that I need to search and see if they are in my list in column E. Is there a way to do it without have to do each individual value?

 

[Jonmo1]

So you just want 1 formula that will tell you if ANY value in G2:G118 exists anywhere in E$2:E$4612.
You have no need to actually identify/flag 'Which' value in G exists in E ?

Try

=IF(SUMPRODUCT(COUNTIF(E2:E4612,G2:G118)),"Found","N")

 

[icomefromchaos]

So you just want 1 formula that will tell you if ANY value in G2:G118 exists anywhere in E$2:E$4612.
You have no need to actually identify/flag 'Which' value in G exists in E ?

Try

=IF(SUMPRODUCT(COUNTIF(E2:E4612,G2:G118)),"Found","N")

I tried this, and it doesn't find any of the values. I'm not sure what I am doing wrong.