Show it here, if it exists there
 

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

Show it here, if it exists there
 

Try:

=IF(COUNTIF(Sheet1!C:C,8),8,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Kevin" wrote in message
...
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

Show it here, if it exists there
 

Try something like this:

On a sheet named Page2:
B1: (the number to find....eg 25)

A1: =IF(COUNTIF(Page1!C:C,B1),B1,"No match")

Is that something you can work with?
***********
Regards,
Ron

XL2003, WinXP


"Kevin" wrote:

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

Show it here, if it exists there
 

Sandy Mann,
Thanks, that works perfectly.
-Kevin


"Sandy Mann" wrote in message
...
Try:

=IF(COUNTIF(Sheet1!C:C,8),8,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Kevin" wrote in message
...
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

Show it here, if it exists there
 

Ron Coderre,
Thanks, that too works perfectly.
-Kevin

"Ron Coderre" wrote in message
...
Try something like this:

On a sheet named Page2:
B1: (the number to find....eg 25)

A1: =IF(COUNTIF(Page1!C:C,B1),B1,"No match")

Is that something you can work with?
***********
Regards,
Ron

XL2003, WinXP


"Kevin" wrote:

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

Show it here, if it exists there
 

You are very welcome. Thank for the feedback.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Kevin" wrote in message
...
Sandy Mann,
Thanks, that works perfectly.
-Kevin