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
[TABLE="width: 192"]
<tbody>[TR]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"]A[/TD]
[TD="class: xl65, width: 64"]B[/TD]
[/TR]
[TR]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]abc[/TD]
[TD="class: xl65"]xyz[/TD]
[/TR]
[TR]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"]4[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"]5[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"]7[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"]8[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"]9[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
</tbody>[/TABLE]


After
[TABLE="width: 192"]
<tbody>[TR]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"]A[/TD]
[TD="class: xl65, width: 64"]B[/TD]
[/TR]
[TR]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]abc[/TD]
[TD="class: xl65"]xyz[/TD]
[/TR]
[TR]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]6[/TD]
[/TR]
[TR]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"]4[/TD]
[TD="class: xl65"]abc[/TD]
[TD="class: xl65"]xyz[/TD]
[/TR]
[TR]
[TD="class: xl65"]5[/TD]
[TD="class: xl65"]abc[/TD]
[TD="class: xl65"]xyz[/TD]
[/TR]
[TR]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]xyz[/TD]
[/TR]
[TR]
[TD="class: xl65"]7[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]xyz[/TD]
[/TR]
[TR]
[TD="class: xl65"]8[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]xyz[/TD]
[/TR]
[TR]
[TD="class: xl65"]9[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]xyz[/TD]
[/TR]
</tbody>[/TABLE]



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.