LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 57
Default Problem searching cell text

Hi,

I posted a prior question about searching text within cells and entering
particular values in another cell if found, or else enter "other" in the
destination cell. I received this formula in response:

=IF(SUM(-ISNUMBER(SEARCH(List,A1)))=0,"Other",
INDEX(List,MATCH(TRUE,ISNUMBER(SEARCH(List,A1)),0) ))

This returns "Other" even when text in the search cell matches text in the
List however. I have included an exact example below. Can anyone tell me
what I am doing wrong?

Search Cells:
A
1 Back Testing
Q2 2008
2 CAT
Q3 2008
3 CAT
4 CAT
Database
XYZ Server
Q3 2008
5 Database
Q2 2008
ROA & SAP

List
Auto Release
Back Testing
Future Support
HW Upgrades
Null & 0 Value Limits
Other Apps
POV Renovation
ROA & SAP
VWAP Rule
XYZ GUI
XYZ Server

My desired result is for the formula to return "Back Testing" when searching
A1, "Other" for A2 & A3, "XYZ Server" for A4, and "ROA & SAP" for A5.

Instead, "Other" is returned each time.

Thank you!

Tom


 
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
Format a text cell for searching DavidM[_2_] Excel Discussion (Misc queries) 1 March 28th 07 03:05 AM
Format a text cell for searching Toppers Excel Discussion (Misc queries) 0 March 28th 07 02:18 AM
Format a text cell for searching DavidM[_2_] Excel Discussion (Misc queries) 0 March 28th 07 01:17 AM
searching a cell for a contained text word Doug K Charts and Charting in Excel 0 June 20th 05 09:10 PM
Searching text in a cell range ShareerIslamabadiMunda Excel Worksheet Functions 7 December 16th 04 09:55 PM


All times are GMT +1. The time now is 03:46 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"