MR T VALKO ..PLZ HELP

[pierre]

hello....need help:

i have :

A B
1 axe red 10
2 axe red 20
3 axe green 30
4 axe pink 40
5 table a 50
6 table a 60
7 table a 70
8 tree a 80
9 tree b 90
10 tree b 100


F2 and beyond is my search string for : tree or table or axe

im inserting the following formula in cell G2 (BUT IT WONT WORK)
{=INDEX($B$2:B2;SMALL(IF(($A$2:A2=TRANSPOSE($f$2:f2));ROW($B$2:B2)-MIN(ROW($B$2:B2))+1);ROWS($B$2:B2)))}...and i dragg down
ALL THAT IN ORDER TO GET THE VALUES OF TREE , TABLE , AXE
HOW TO DO THAT??

 

[T. Valko]

I thought we had this straightened out?

That formula doesn't look like the formula I suggested here that works:

http://tinyurl.com/5hszww