excel to return data based on number inserted

[syamsulamri]

Hi excel expert,
is there any formula taht i can use as per data below:

Before

	A	B
1	abc	xyz
2
3
4
5
6
7
8
9

<tbody>
</tbody>

After

	A	B
1	abc	xyz
2	2	6
3
4	abc	xyz
5	abc	xyz
6		xyz
7		xyz
8		xyz
9		xyz

<tbody>
</tbody>

when i put number in cell a2 (2), automatically abc will appear in call a4 and a5
when i put number in cell B6 (6) automatically xyz will appear in cell b4 to b9.

Is this possible?

Thanks

 

[jtakw]

Hi,

May be this:

Book1
	A	B
1	abc	xyz
2	2	6
3
4	abc	xyz
5	abc	xyz
6		xyz
7		xyz
8		xyz
9		xyz
10
11
12
Sheet308

Cell Formulas
Range	Formula
A4	=IF(COUNTIF(A$3:A3,A$1))

A4 formula copied down and across as far as needed.

 

[Marcelo Branco]

Try

Formula in A4
=IF(ROWS(A$4:A4)>A$2,"",A$1)
copy down to as many rows as you want

Formula in B4
=IF(ROWS(B$4:B4)>B$2,"",B$1)
copy down to as many rows as you want

M.

 

[syamsulamri]

Great!! Thanks mate

 

[jtakw]

You're welcome.