If formula question, please

[fordguy]

I tried getting this i have most of it but i am stumped on the majority

here is what i would like help on


if j10 =1 copy the contents of j2 to c3

if j10 =2 copy the contents of j2 to c4

if j10 =3 copy the contents of j2 to c5

[Domenic]

Try...

C3: =IF(J10=1,J2,"")

C4: =IF(J10=2,J2,"")

C5: =IF(J10=3,J2,"")

Alternatively, you could enter the following formula in C3 and copy down:

=IF($J$10=ROW()-ROW($C$3)+1,$J$2,"")

Hope this helps!

[fordguy]

thank you that helped alot , where do u people find all this neat stuff

[Domenic]

thank you that helped alot

You're very welcome!

...where do u people find all this neat stuff

In my case, by frequenting Boards, newsgroups, etc., and learning from others.