multiple lookups using index small

[nehpets12]

I need a formula for going across the columns

using this array formula {=INDEX($I$2:$I$21,SMALL(IF($H$2:$H$21=$A$2,ROW($H$2:$H$21)-1),ROW()-1))}

this works when copying the formula down a column

Vliookup differant rows New.xls
	A	B	C	D	E	F	G	H	I
1
2	Monday	1						Monday	1
3		3						Tuesday	2
4		4						Monday	3
5		11						Monday	4
6		18						Tuesday	5
7		#NUM!						Wednesday	6
8		#NUM!						Thursday	7
9		#NUM!						Friday	8
10		#NUM!						Saturday	9
11		#NUM!						Sunday	10
12								Monday	11
13								Tuesday	12
14								Wednesday	13
15								Thursday	14
16								Friday	15
17								Saturday	16
18								Sunday	17
19								Monday	18
20								Tuesday	19
21								Wednesday	20
Sheet3

What I want is to amend the formula so I can copy it from B2 To G2

 

[Peter_SSs]

Try:
=INDEX($I$2:$I$21,SMALL(IF($H$2:$H$21=$A$2,ROW($H$2:$H$21)-1),COLUMNS($B2:B2)))
Still confirmed with Ctrl+Shift+Enter

 

[Andrew Poulsom]

Try:

=INDEX($I$2:$I$21,SMALL(IF($H$2:$H$21=$A$2,ROW($H$2:$H$21)-1),COLUMN()-1))

 

[nehpets12]

Thank You