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.