Not sure what im doing wrong with the index function

[DeanRobinson]

This is probably a really simple one but i cant seem to understand why its doing it.

i have two rows lets say A and B

in A i have the formula
{=SMALL(IF([TECHTM.xls]Sheet1!$B$2:$B$88=$A$1,ROW([TECHTM.xls]Sheet1!$B$2:$B$88)),ROW(1:1))}

which works and returns row say

7
8
11
12

then in B i have a formula
{=INDEX([TECHTM.xls]Sheet1!$A$2:$B$88,SMALL(IF([TECHTM.xls]Sheet1!$B$2:$B$88=$A$1,ROW([TECHTM.xls]Sheet1!$B$2:$B$88)),ROW(1:1)),1)}

which should just be giving the value of row 7,8,11,12, but for some reason its jumping down a cell and returning the values of 9,10,12,13. any help would be great, ive never used small or index before. so not to sure what im doing.

 

[Benjaminmin]

then in B i have a formula
{=INDEX([TECHTM.xls]Sheet1!$A$2:$B$88,SMALL(IF([TECHTM.xls]Sheet1!$B$2:$B$88=$A$1,ROW([TECHTM.xls]Sheet1!$B$2:$B$88)),ROW(1:1)),1)}

Not completely sure, but what happens if you just use:

{=INDEX([TECHTM.xls]Sheet1!$A$2:$B$88,SMALL(IF([TECHTM.xls]Sheet1!$B$2:$B$88=$A$1,ROW([TECHTM.xls]Sheet1!$B$2:$B$88)),ROW(1:1)))}

 

[DeanRobinson]

i get a #REF error.

 

[DeanRobinson]

no ideas??