IF(A=A;Do Something;Do nothing (leave value as it is, so do not alter to null or space)

[brundela]

A given table:

	A	B	C	D	E	F
1	H					1
2	H
3	H
4	H

<tbody>
</tbody>

Depending on a value I do want to change the values in col-1, 2, 3 or 4. Lets say:
A1, A2, A3 & A4 contains the formula: IF($F$1=1;"H";"")
B1, B2, B3 & B4 contains the formula: IF($F$1=2;"R";"")

By changing the value of F1 in 2 the table will looks like:

	A	B	C	D	E	F
1		R				2
2		R
3		R
4		R

<tbody>
</tbody>

But I want it to be:

	A	B	C	D	E	F
1	H	R				2
2	H	R
3	H	R
4	H	R

<tbody>
</tbody>

Is there a way to achieve this?​

 

[steve the fish]

Heres a way:

=IF(COLUMN()<=$F$1,CHOOSE(COLUMN(),"H","R"),"")