Input a value and capture the next 5 values

[danallamas]

I have a list of week numbers and I need to be able to put a week# and the next columns will automatically capture the next 5 weeks. So next 5 week # will be based from the first week # value.

Input Value changes when h3 value changes
WC0105 WC0112 WC0119 WC0126 WC0202

WC0112 WC0119 WC0126 WC0202 WC0209


Week
WC0105
WC0112
WC0119
WC0126
WC0202
WC0209
WC0216
WC0223
WC0302
WC0309
WC0316
WC0323
WC0330
WC0406
WC0413
WC0420
WC0427
WC0504
WC0511
WC0518
WC0525
WC0601
WC0608
WC0615
WC0622

[Phuocam]

Please post a sample file.

[Tony Valko]

Try this...

Data Range

	A	B	C	D	E	F	G
1	Week	------	Week
2	WC0105		WC0209	WC0216	WC0223	WC0302	WC0309
3	WC0112
4	WC0119
5	WC0126
6	WC0202
7	WC0209
8	WC0216
9	WC0223
10	WC0302
11	WC0309
12	WC0316
13	WC0323
14	WC0330
15	WC0406
16	WC0413
17	WC0420
18	WC0427
19	WC0504
20	WC0511
21	WC0518
22	WC0525
23	WC0601
24	WC0608
25	WC0615
26	WC0622

C2 = some week number

Enter this formula in D2 and copy across to G2:

=IFERROR(INDEX($A2:$A26,MATCH($C2,$A2:$A26,0)+COLUMNS($D2:D2)),"")