Searching a column and returning a yes or no answer
 

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 <------ Found - return a YES
1284
1294
1305
1308
1910
1950
2000


If not found then return no

Searching a column and returning a yes or no answer
 

one way

=IF(COUNTIF(F4:F10,C4)0,"yes","no")


--
Greetings from New Zealand
Bill K

wrote in message
oups.com...
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 <------ Found - return a YES
1284
1294
1305
1308
1910
1950
2000


If not found then return no