IF Formula

[Guest]

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

 

[Biff]

Hi!

Try this:

=IF(ISNUMBER(MATCH(A2,G:G,0)),INDEX(A11,MATCH(A2,A22,0)),"")

Biff

 

[Biff]

P.S.

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

Biff

 

[Guest]

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]

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 here:

http://skin2skin.proboards21.com/index.cgi?board=sports&action=display&thread=1125372105

Biff

 

[Guest]

That is to funny.... Well maybe you can help me out with this one... You can
send to (e-mail address removed) 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!