Dear NG:

I have a list of different numbers in column C of page 1.
I would like Excel to search that list for a certain number
and if it exists anywhere in that column, then display it in
column A of Page 2

The IF function seems to only search one row in column C of page 1
(The same row that I enter the formula in on page 2)

I need it to search the entire column for the specific number.

I hope I've supplied enough information.

Thanks for any assistance.

-Kevin