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
What I want is to amend the formula so I can copy it from B2 To G2
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