software

Simple as it sounds I am trying to enter an number in a given cell.
That cell would then search a column and see if there is the number
that was
entered into the cell. If the number matches return a Yes if it does
not return a NO.

Example:

Enter a number in C4 cell. (1264)

or (1286)Search column of numbers to see if number is in there as an exact
match.

F4:F10

1234
1244
1264 lt;------ Found - return a YES
1284
1294
1305
1308
1910
1950
2000If not found then return no
one way

=IF(COUNTIF(F4:F10,C4)gt;0,quot;yesquot;,quot;noquot;)--
Greetings from New Zealand
Bill K

gt; wrote in message oups.com...
gt; Simple as it sounds I am trying to enter an number in a given cell.
gt; That cell would then search a column and see if there is the number
gt; that was
gt; entered into the cell. If the number matches return a Yes if it does
gt; not return a NO.
gt;
gt; Example:
gt;
gt; Enter a number in C4 cell. (1264)
gt;
gt; or (1286)
gt;
gt;
gt; Search column of numbers to see if number is in there as an exact
gt; match.
gt;
gt; F4:F10
gt;
gt; 1234
gt; 1244
gt; 1264 lt;------ Found - return a YES
gt; 1284
gt; 1294
gt; 1305
gt; 1308
gt; 1910
gt; 1950
gt; 2000
gt;
gt;
gt; If not found then return no
gt;