Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Row reference increment but preserve column reference | Excel Worksheet Functions | |||
Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) |