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?????