Use this formula as an array in c8 and drag across
=IFERROR(INDEX(database!A$1:A$2500,SMALL(IF(LEN(SUBSTITUTE(UPPER(database!$A
$1:$A$2500),UPPER(Sheet2!$E$3),""))<LEN(UPPER(database!$A$1:$A$2500)),ROW(IN
DIRECT("1:"&ROWS(database!$A$1:$A$2500))),""),ROW()-7)),"")
Regards,
Sam Mathai Chacko
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chandra sekaran
Sent: Thursday, February 16, 2012 7:34 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Search Engin
Dear all
Here with attached Seach Engines 2003. which is get from this group . i
need one more step ahead for this when i enter the Seach Criteria like
Mohan it will come all Start with Mohan is it possible or if enter one
word only Delar name start with enterd name should come plese ...
Regards
chandru
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
