Hello,

I am hoping someone might be able to help with this. I am trying to come up with a sheet for my Fantasy Football league's draft. I have one worksheet that has the entire draft. Then I have a worksheet for each team. This has a table that autopopulates from the original draft, showing who each team has drafted. Also, there is another table on this worksheet that shows the full roster for the team.

Here's the problem. We draft multiple players at a couple of positions. So, I have been able to use the IF function to scan the data table for position players. (i.e. =IF(H6="QB",G6, IF(H7="QB", G7, IF(H8="QB", G8, IF(H9="QB", G9, IF(H10="QB", G10, IF(H11="QB", G12, IF(H13="QB", G13)))))))
So that it will autopopulate the QB position on the table. The problem I have is with the positions we draft more than one of. So for RB, it will autopopulate from the draft table, but it will put the first RB selcted at both cells.

Is there some way to have the first RB cell search through the data table and autopopulate. And then have the second RB cell compare itself with the first cell, and put in the next player?

Thank you.

Hi!

This shouldn't be too difficult but it's hard to give
advice without seeing the file. If you want to send me a
copy I'll take a look.

Biff

-----Original Message-----

Hello,

I am hoping someone might be able to help with this. I
am trying to
come up with a sheet for my Fantasy Football league's
draft. I have
one worksheet that has the entire draft. Then I have a
worksheet for
each team. This has a table that autopopulates from the
original
draft, showing who each team has drafted. Also, there is
another table
on this worksheet that shows the full roster for the team.

Here's the problem. We draft multiple players at a
couple of
positions. So, I have been able to use the IF function
to scan the
data table for position players. (i.e. =IF(H6="QB",G6,
IF(H7="QB",
G7, IF(H8="QB", G8, IF(H9="QB", G9, IF(H10="QB", G10,
IF(H11="QB",
G12, IF(H13="QB", G13)))))))
So that it will autopopulate the QB position on the
table. The problem
I have is with the positions we draft more than one of.
So for RB, it
will autopopulate from the draft table, but it will put
the first RB
selcted at both cells.

Is there some way to have the first RB cell search
through the data
table and autopopulate. And then have the second RB cell
compare
itself with the first cell, and put in the next player?

Thank you.


--
imjoel
.

Biff,

What's your e-mail address and I'll send it over.

Thank you,

-Joel

Hi!

You should have stayed in the original thread! I may not
have seen this post!

Valko 01 is at com cast period ten.

Reverse ten. Take out all the spaces and is.

Biff

-----Original Message-----

Biff,

What's your e-mail address and I'll send it over.

Thank you,

-Joel

Biff Wrote:
Hi!

This shouldn't be too difficult but it's hard to give
advice without seeing the file. If you want to send me a
copy I'll take a look.

Biff
-
-----Original Message-----

Hello,

I am hoping someone might be able to help with this. I-
am trying to-
come up with a sheet for my Fantasy Football league's-
draft. I have-
one worksheet that has the entire draft. Then I have a-
worksheet for-
each team. This has a table that autopopulates from
the-
original-
draft, showing who each team has drafted. Also, there
is-
another table-
on this worksheet that shows the full roster for the
team.

Here's the problem. We draft multiple players at a-
couple of-
positions. So, I have been able to use the IF function-
to scan the-
data table for position players. (i.e. =IF
(H6="QB",G6,-
IF(H7="QB",-
G7, IF(H8="QB", G8, IF(H9="QB", G9, IF(H10="QB",
G10,-
IF(H11="QB",-
G12, IF(H13="QB", G13)))))))
So that it will autopopulate the QB position on the-
table. The problem-
I have is with the positions we draft more than one of.-
So for RB, it-
will autopopulate from the draft table, but it will put-
the first RB-
selcted at both cells.

Is there some way to have the first RB cell search-
through the data-
table and autopopulate. And then have the second RB
cell-
compare-
itself with the first cell, and put in the next player?

Thank you.


--
imjoel
.
-


--
imjoel
.