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

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

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

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

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

That is to funny.... Well maybe you can help me out with this one... You can
send to I will try to show you what I am doing with mine
as well... I think it is pretty close.... I use spreads and each perosn only
picks 6 teams and then ranks them 6 - 1.... 6 being the most likely winner,
if you get all 6 correct it is 21 points.........

drop me an e-mail and I will show you teh work sheet.

Thanks!

"Biff" wrote:

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