Hi!

What a coincidence!

I run a NFL pool and have a file that you can probably use.

Want a copy? If so, just let me know where to send it.

You can see a few screencaps of what (some of) it looks like he

http://skin2skin.proboards21.com/ind...d=11253 72105

Biff

"Cooch1070" wrote in message
...
Basically, I am creating a sheet that deal with an NFL pool. People pic
six
winners.... I want to create teh formulea sho all I need to do is enter
the
user picks and then the winning teams each week... It is hard to show
here,
but on column would only be winners and then each row would be represented
by
the players of that week. they pick 6 games, then the formula woudl then
read
teh winning team column against the selected teams and give a popint value
to
that pick...I woudl have 6 formulas per player(participant) Does that make
sense?

"Biff" wrote:

P.S.

That formula is based on your posted table. (which doesn't make any sense
to
me!)

Biff

"Biff" wrote in message
...
Hi!

Try this:

=IF(ISNUMBER(MATCH(A2,G:G,0)),INDEX(A1:D1,MATCH(A2 ,A2:D2,0)),"")

Biff

"Cooch1070" wrote in message
...
I am trying to create a formula that will read a name and if that name
matches in another column, then it would return a value in a
represented
cell.

Column A B C D E F G
Row 1 6 5 4 3
ROW 2 Jags Eag Boy Bucs Tom
Row 3 Jerry
Row 4 Eag
Row 5 Fred

I need the one formulae to say if A2's values is represented anywhere
in
column G, then return the value of 6. So for instance, B2, has a name
Eag,
that value is one of the values in column G. I would need the formula
to
return the value of 5. Any help?????