hello ..... i have 2 questions :

first question :
given :

A B
1 max 20
2 cliff 5
3 cliff 38
4 max 40
5 cliff 60
6 dot 50
7 cliff 60
8 cliff 60
9 cliff 78
10 cliff 60
11 dot 44

i have entered in cell C1 : "max"
NOW i want a formula in cell D1 which lets me have ALL
related results to "max"

second question :
given :

A B C D
1 a 10 2 d 40
2 b 20 3 e 50
3 b 30 4 f 60

i want the search string cell to be E1 in order to enter : a ,b,c,d,e,f
in order to get their correspondent results
WHAT TO USE HERE ?? index(...(match)).....maybe ?