LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 90
Default Search a cell for a specific number

Hey there,
I'm trying to do the following:
ColB contains either 1,2, or 3
ColC contains a combination of 12,21,23,32,13 or 31

What I'm looking is in ColD, to check the number in B3 and see if it's one
of the numbers in C2. So, for example:

ColB ColC ColD
1
2 12
3 23 No Match - since 3 (B3) isn't part of 12 (C2), it's a no
match
3 23 Match - since 3 (B4) is a part of 23 (C3), it's a match
1 13
2 12

Thanks!
Matt

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search for specific number in a range Ruan[_2_] Excel Worksheet Functions 1 December 10th 07 12:43 PM
Search for a number in a table and return data of a specific cell Karaman Excel Discussion (Misc queries) 4 June 30th 06 03:46 PM
Search for record with specific name in a cell pomalley Excel Worksheet Functions 2 November 17th 05 02:44 PM
How do I search for specific text and sum the cell to the right? PacRat2001 Excel Worksheet Functions 3 October 12th 05 04:21 AM
Search for a specific character in a cell in an if statement mcl Excel Worksheet Functions 2 January 4th 05 09:14 PM


All times are GMT +1. The time now is 06:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"