View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pierre Pierre is offline
external usenet poster
 
Posts: 149
Default MR T VALKO ..PLZ HELP

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??