You're welcome. and thank you for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jambruins" wrote in message
...
thanks, it works perfectly

"RagDyeR" wrote:

Try this non-volatile formula:

=INDEX($B$1:$C$170,ROWS($1:2)/2,MOD(ROWS($1:1)-1,2)+1)

And copy down.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Jambruins" wrote in message
...
I have text in columns B and C from row 1 to 170. The formula in cell H1
is
=B1 so it displays the text from B1. The formula in cell H2 is =C1 so it
displays the text from C1. I would like to copy this all the way down
but
it
skips row 2 and pulls the text from cells B3 and C3. I would like to use
a
formula in cell H3 to find the text in cell B2 and a formula in cell H4
to
find the text in cell C2. Then I want to be able to copy this down the
whole
sheet. Thanks.