multiple match from a column

A

arun_bhilai

hai every body.
i m in a real bad fix.
i have a column containing names and other column containig their respective
datas. i made a function that when i will enter any name i will get the
datas. but the loop hole is that i will have to enter the name exactly as in
the data sheet. now i want that if i have two names eg: joe and john and only
if i enter jo i shall get both the match.
is this possible.
please help.
thanks in advance.
 
C

CyberTaz

Can't say because you don't give any indication what type of 'function' you
'made' - that can make a big difference. However, there are at least 3 ways
I would go without needing a function at all:

1- Use Edit>Find. Type jo* into the Find What: box & check the box for
'Match entire cell contents', click Find Next or Find All for a list,

2- Click in the list & Use the Data>Filter>AutoFilter: Click the button for
the Name field, select (Custom) & type jo* into the top right criteria
field, click OK to get a collapsed list of records whose name begins with
jo, or

3- Click in the list & use Data>Form: Click the Criteria button & type jo in
the Name field, then click Find Next to navigate through the matching
records.

If you need to have the found records copied to another location you might
also investigate the Data>Filter>Advanced Filter.
 
A

arun_bhilai

thanks buddy for the help.
but what exactly i need is some thing different. the formula i have used is
INDEX(CONTACTS!B3:C200,MATCH(C5,CONTACTS!B3:B200,0),2)
here my name list along with the datas is on a sheet called CONTACTS and i
enet the name to find out on a seperate sheet called INFO C5.
basically what i want is that if there are entries as JOE and JOHN and i
only enter JO in INFO C5 i shall get both the matches and then when i select
the name that i need i shall get all the data.
i hope that this time i had told the problem more specifically.
i greatly appereciate the help i got from yur side.
thanks dear.
 
Top