[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:f 2));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

--
Biff
Microsoft Excel MVP


"pierre" wrote in message
...
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:f 2));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??