I don't quite understand what you mean by criteria for a1:a10. I'm pretty new
to excel.
Just to put my question in perspective...
this is an example of what i'm doing:
http://office.microsoft.com/en-us/as...0corresponding
As you will see at the bottom of the above page/link i put the value
"ashish"in a10, and it returns corresponding numbers.
if i replace "ashish" with "sh"in a10, i need to get all the corresponding
values from column b, for every cell in column a that has "sh", which would
mean it gives me the following values:

a b
10 sh 234
11 534
12 634
13 734
14 834
since(sh is a part of a1,a4,a5,a6,a7)
Hope this clarifies it a little better!
Do let me know if you figure it out!
Thanks for your help!


"Domenic" wrote:

Can you specify the criteria for A1:A10?

In article ,
xlarch wrote:

hey i'm using the same formula, and would like to search with a wildcard
...can someone help?
eg:
IF(ISERROR(INDEX($A$1:$B$10,SMALL(IF($A$1:$A$10=$A $10,ROW($A$1:$A$10)),ROW(1:1
)),2)),"",INDEX($A$1:$B$10,SMALL(IF($A$1:$A$10=$A$ 10,ROW($A$1:$A$10)),ROW(1:1)
),2))
Now i need to replace (if($a$1:$a$10= ($a$10 (i need to add a wildcard
here..how?,ROW......)