Row based on the lookup

[SAXON10]

Hi,

Is there a possible way for my requirements? it would much grateful if I get any help.

Row reference based on the lookup and return lookup values according to my conditions

Column B2:J2 contain as a text A,B,C,D & E and corresponding to the code ( B3:B7, C3:C7, D3:D8, E3:E7 & F3:F7)

There shouldn’t be a gap between in Text A & B corresponding to the code.

Text D - corresponding to the code, In between every 8^th row I require a Gap.

Text E - corresponding to the code, In between every 5^th row I require a Gap.

Text F - corresponding to the code, In between every 3^th row I require a Gap.

Please refer condition in A1:F1.



https://www.dropbox.com/s/qbrro277q9ttan0/GAPS.xlsx?dl=0

https://www.dropbox.com/s/1xhbwzbt4qa8omp/GAPS.PNG?dl=0

 

[Peter_SSs]

Try this, copied across and down.

Excel Workbook
	A	B	C	D	E	F
1	DATA
2	GAP OF ROW	0	0	8	4	2
3	TEXT	A	B	C	D	E
4	CODE	10	10	60	111	10
5		20	20	90	789	20
6		30	30	30	225	30
7		40	40	78	879	40
8		50	50	50	600	50
9				21
10	REQUIREMENT
11	TEXT	A	B	C	D	E
12		10	10	60	111	10
13		20	20	60	111	10
14		30	30	60	111
15		40	40	60	111	20
16		50	50	60		20
17				60	789
18				60	789	30
19				60	789	30
20					789
21				90		40
22				90	225	40
23				90	225
24				90	225	50
25				90	225	50
26				90
27				90	879
28				90	879
29					879
30				30	879
31				30
32				30	600
33				30	600
34				30	600
35				30	600
36				30
37				30
38
39				78
Sheet2

 

[SAXON10]

Thanks for your help. Formula working fine.

 

[Peter_SSs]

Thanks for your help. Formula working fine.

You're welcome. Thanks for letting us know.