Formula Help

[accountant85]

Hello,

Trying to set up a draft board for a fantasy football draft:

Below is the set up I have in my spreadsheet now. I am trying to get a formula that will pull the name of the first QB selected to the QB line below, the second QB selected to the bench. I want the first RB picked to go to the first RB slot, the second RB picked go to second RB spot, third RB selected to go to flex (if flex spot is empty - go to bench). And so on...

Any suggestions for formulas?

[TABLE="width: 10"]
<tbody>[TR]
[TD]ROUND[/TD]
[TD]POSITION[/TD]
[TD]NAME[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]QB[/TD]
[TD]A. SMITH[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]RB[/TD]
[TD]B. SMITH[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]WR[/TD]
[TD]C. SMITH[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]TE[/TD]
[TD]D. SMITH[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]D/ST[/TD]
[TD]E. SMITH[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]K[/TD]
[TD]F. SMITH[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]QB[/TD]
[TD]G. SMITH[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]RB[/TD]
[TD]H. SMITH[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]WR[/TD]
[TD]I. SMITH[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]TE[/TD]
[TD]J. SMITH[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]WR[/TD]
[TD]K. SMITH[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]RB[/TD]
[TD]L. SMITH[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]RB[/TD]
[TD]M. SMITH[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]WR[/TD]
[TD]N. SMITH[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]QB[/TD]
[TD]O. SMITH[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]WR[/TD]
[TD]P. SMITH[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]QB[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RB[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RB[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FLEX[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FLEX[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D/ST[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]K[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BENCH[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BENCH[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BENCH[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BENCH[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BENCH[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BENCH[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BENCH[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]