Search with multiple results
 

Hello,
I've tried to follow the instructions for the search with multiple results:
http://office.microsoft.com/en-us/ex...CL100570551033

However, the data I'm trying to pull a list of is on a separate worksheet. I
need to have the search find the character string I specify and return all of
the results. Basically the example in the tutorial is exactly what I need
except that when I specify a range within the other worksheet I'm only
getting one hit, and its wrong. When I copy the formula down a row it gives
me errors. So far I'm not having any luck. All help is appreciated.
Regards,
Sean

Search with multiple results
 

=INDEX(Sheet2!$A$1:$B$7,SMALL(IF(Sheet2!$A$1:$A$7= $A$10,ROW($A$1:$A$7)),ROW(1:1)),2)


Entered with Ctrl+Shift+enter rather than just enter.

then select the cell and drag fill down the column until it returns error
values.

make sure the values on the other string don't have blank spaces at the
beginning or end - anything that would make them not match.

--
Regards,
Tom Ogilvy


"Sean" wrote in message
...
Hello,
I've tried to follow the instructions for the search with multiple
results:
http://office.microsoft.com/en-us/ex...CL100570551033

However, the data I'm trying to pull a list of is on a separate worksheet.
I
need to have the search find the character string I specify and return all
of
the results. Basically the example in the tutorial is exactly what I need
except that when I specify a range within the other worksheet I'm only
getting one hit, and its wrong. When I copy the formula down a row it
gives
me errors. So far I'm not having any luck. All help is appreciated.
Regards,
Sean

Search with multiple results
 

Thanks, Tom. Much appreciated!

"Tom Ogilvy" wrote:

=INDEX(Sheet2!$A$1:$B$7,SMALL(IF(Sheet2!$A$1:$A$7= $A$10,ROW($A$1:$A$7)),ROW(1:1)),2)


Entered with Ctrl+Shift+enter rather than just enter.

then select the cell and drag fill down the column until it returns error
values.

make sure the values on the other string don't have blank spaces at the
beginning or end - anything that would make them not match.

--
Regards,
Tom Ogilvy


"Sean" wrote in message
...
Hello,
I've tried to follow the instructions for the search with multiple
results:
http://office.microsoft.com/en-us/ex...CL100570551033

However, the data I'm trying to pull a list of is on a separate worksheet.
I
need to have the search find the character string I specify and return all
of
the results. Basically the example in the tutorial is exactly what I need
except that when I specify a range within the other worksheet I'm only
getting one hit, and its wrong. When I copy the formula down a row it
gives
me errors. So far I'm not having any luck. All help is appreciated.
Regards,
Sean