Insert rows below each record, then insert new column with vlookup and if formula

I'm not sure why, but I can't upload my Excel spreadsheet or a jpeg.

1. I want to take data lines and then add 3 rows below each record.
2. Insert a "NEW CODE" column anywhere (it's at the right end right now)
3. Use vlookup to populate the "NEW CODE" based on Code 1
4. Populate the new blank cells based on the "NEW CODE"

Is this doable?

Thanks!

forum.ozgrid.com/index.php?attachment/56377/

Re: Insert rows below each record, then insert new column with vlookup and if formula

anyone?