Originally Posted by Biff

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
.