Okay, I apologize if this has been answered repeatedly. I'm a newbie and am not sure what verbiage to use in order to return an answer.

I'm creating a worksheet that populates from a table in a different worksheet by using and IF function with multiple criteria. The formula is created and is working, however I'd like to have it populate as follows:

Example:
Source table:
1
2
3
4
5
6
7
8

Would like it to populate the cells in a manner such as this: (|) represents adjacent cell

| 1 | 5 |
| 2 | 6 |
| 3 | 7 |
| 4 | 8 |

As it is now when I drag the fill box, it fills like this:

| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |

Any suggestions on how I can identify the cell range to be "printed to", so that I don't have to go in and manipulate the function at the top of each column?
Thanks for any help you can provide. (my apologies again for the poor verbiage)