Hi Lisa
in column B enter this formula and copy all the way down, it will do the trick

=+IF(A2="",A3,A4)

"Lisa" wrote:

Hello.

In this particular spreadsheet, I have a value (an ID #) in A2.
However...A3, A4, and A5 are blank. A6 starts over with another unique ID
number.

I need the ID number to appear in every cell in the column. For example: if
A2 value is 445...I want A3 A4 and A5 to show 445. Then, when A6 changes to,
say, 778, I want A7 A8 and A9 to show 778. The reason is because I need to do
a v-lookup for data in column I5 (etc). Using the auto-fill from the corner
of each A2, A6 cell is too time consuming as the spread is huge.

Is there a formula that will do this for the whole column? Thanks much!