Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Show Existing IE Instance if Already Exists, Else Open One | Excel Discussion (Misc queries) | |||
A value exists in a list? | Excel Discussion (Misc queries) | |||
File Exists | Excel Discussion (Misc queries) | |||
Need help with a function I'm not sure exists | Excel Worksheet Functions | |||
Sheet name already exists | Excel Discussion (Misc queries) |