Excel 2007 - I need to do a reference on every other row for another column
to bring over some data. So for example:

row 1 Column A Column B
row 2 4229
row 3 $1000
row 4 5667
row 5 $2500


So I want in row2 column C "4229" and in row 2 column D $1000. In row 4
column C "5667" and in row 4 column D $2500 and so on. I need to bring up
the dollar amount to the row above it so I can perform a vlookup on column A
to bring over the corresponding dollar amount.

In C2 put the formula =IF(A2="","",A2)
In D2 put the formula =IF(B3="","",B3)
Copy down as far as required.
--
David Biddulph

"duketter" wrote in message
...
Excel 2007 - I need to do a reference on every other row for another
column
to bring over some data. So for example:

row 1 Column A Column B
row 2 4229
row 3 $1000
row 4 5667
row 5 $2500


So I want in row2 column C "4229" and in row 2 column D $1000. In row 4
column C "5667" and in row 4 column D $2500 and so on. I need to bring up
the dollar amount to the row above it so I can perform a vlookup on column
A
to bring over the corresponding dollar amount.

In C2:
=IF(MOD(ROW(),2),"",OFFSET(A2,MOD(COLUMN()+1,2),))

Copy across to column D, and downward as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"duketter" wrote:

Excel 2007 - I need to do a reference on every other row for another column
to bring over some data. So for example:

row 1 Column A Column B
row 2 4229
row 3 $1000
row 4 5667
row 5 $2500


So I want in row2 column C "4229" and in row 2 column D $1000. In row 4
column C "5667" and in row 4 column D $2500 and so on. I need to bring up
the dollar amount to the row above it so I can perform a vlookup on column A
to bring over the corresponding dollar amount.