reference every other row

[duketter]

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.

 

[NBVC]

You can use perhaps Index/Match directly on that column without having
to create 2 new columns...

e.g.

=Index(A:A,Match(X1,A:A,0)+1)

this looks up item that is in X1 and finds it in column A and returns
the value that is one row beneath the found item....


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)

 

[David Biddulph]

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

 

[Luke M]

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

Copy across to column D, and downward as needed.