Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default Function to determine if any cell in a range is contained in a given cell

Is there an Excel function that can determine if any value in a range
is contained in a given cell.

Ex

Range - CC, DD, EE, FF, QQ
Cell - Yabbadee

Desired function would indicate that EE was found in cell (last 2 chars
of Yabbadee).

VLOOKUP would not indicate that EE was found in the cell (exact match
required). If the cell value however was CC, DD, EE, FF, or QQ it
would find a match.

TIA

  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

With the your range in A1:A5 and the word in C1, put this
in B1 and fill down:

=IF(COUNTIF($C$1,"*"&A1&"*"),"found","")

HTH
Jason
Atlanta, GA

-----Original Message-----
Is there an Excel function that can determine if any

value in a range
is contained in a given cell.

Ex

Range - CC, DD, EE, FF, QQ
Cell - Yabbadee

Desired function would indicate that EE was found in

cell (last 2 chars
of Yabbadee).

VLOOKUP would not indicate that EE was found in the cell

(exact match
required). If the cell value however was CC, DD, EE,

FF, or QQ it
would find a match.

TIA

.

  #4   Report Post  
Choxio
 
Posts: n/a
Default

Domenic and Jason,

I thank you both so much. It was really getting under my skin that I
couldn't find an answer for this. And I have one further question to
you both. Do either of you have suggestions on a good example-driven
web site or book covering more advanced usage of functions. I was at
the point where I was going to write a VB macro to iterate through the
range. Actually if you have suggestions for a great VB macro book site
I would find that most useful as well.

Again thanks so much :-

Reply
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
function cell range limitations AXA Excel Worksheet Functions 3 January 31st 05 12:09 AM
Displaying value of specific cell within a range, with IF function...? Steve Excel Discussion (Misc queries) 1 January 14th 05 03:23 AM
How can I shift cell range contents by using a function? spydog27 Excel Worksheet Functions 1 December 23rd 04 09:40 AM
which formula or function searches for a value in a range of cell. Roccobarocco Excel Worksheet Functions 5 December 3rd 04 01:06 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 08:52 PM.

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

About Us

"It's about Microsoft Excel"