REVERSE the data corresponding to value in the flag cell

[hsandeep]

My Data range is B2:F11 with a flag in corresponding row cell in A2:F11
This flag in A2:F11 is EITHER of 1 OR 0
Output required as in H2:L11 as:
If flag is 1, then corresponding row in H2:L11 SHOULD BE ‘SAME’
If flag is 0, then corresponding row in H2:L11 SHOULD BE ‘REVERSED’

How to accomplish?
Thanks in advance
I am using Excel 2007
Sheet1

	A	B	C	D	E	F	G	H	I	J	K	L
2	1	77	88	99	100	200		77	88	99	100	200
3	0	22	33	44	55	66		66	55	44	33	22
4
5
6
7
8
9
10
11	1	44	12	50	5	2		44	12	50	5	2

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 10px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"></colgroup><tbody>
</tbody>

 

[hsandeep]

Worksheet Formulas Cell Formula N24 =IF($K1=1,D12,INDEX($D12:$H12,COLUMNS($D12:$H12)+1-COLUMNS($N24:N24))) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

[/QUOTE]

Marvelous Visualization….Thanks Peter SS….IT WORKS

 

[Peter_SSs]

Marvelous Visualization….Thanks Peter SS….IT WORKS

Thanks. You're welcome.