|I'm sure there's more to this than you've told us, but one way to get what you want is to try this:|
1 - Copy the formula into the cell in the next column, which will give you the column offset that you want
2 - Move your cursor over the outline of the cell until it turns into 4 arrows
3 - Drag the cell contents to the cell where you want it and it will retain the column offset.
Posting Tip: Before posting Data or VBA Code, read this How-To.