issue....

[pierre]

hi guys , please i need your advice on this one :
i have the following given :

A B
1 max 10
2 ralph 20
3 max 30
4 max 40
5 ralph 50

i would like to have the related results of "max" and "ralph"...how can
this be achieved ??? index(...,small(...) ) maybe ??? HOW ????

 

[pierre]

knowing that my search string is in cell C:C for "ralph" and for "max"
i mean that if i want to enter "ralph" i want results : 20 , 50
and i i want to enter " max" i want results :10 , 30 , 40

 

[T. Valko]

See your other post where I make a suggestion that returns the results in a
vertical array. I'm wondering if what you *really* want are the results in a
horizontal array. Be more specific.