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