Lookup/Reference Help - Multiple lookup ranges

[brianharg]

Not sure I am on the right track - let me try to explain what I am trying to do. I am running a "survivor" pool (person picks a team each day - if they win - they keep going - if the pick a loser, they are out).

What I want to do - is look at the pick they made on the day, check to see if it is a loser - then note if they are still "In" - or if they got knocked out. If they get knocked out, I want to say which day they lost. Following is a picture that shows what I am doing for "day 1" and I got it to work for that specific day. I am using another tab (named Survivor Support) that will list the losers each day (specific to the day). Day 1 will be in column C of that tab. Day 2 will be in G and Day 3 in column K. Using the formula in B3 & 4 - all good - tells me if on the 1st day they are in or out - B3 returns "In" and B4 Returns "Out - Day 1"


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]a [/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]In[/TD]
[TD]Day 1[/TD]
[TD]Day 2[/TD]
[TD]Day 3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Player Name[/TD]
[TD]Out[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Bill[/TD]
[TD]=IF(ISERROR(VLOOKUP(C5,'Survivor Support'!$C$3:$C$34, 1, FALSE)),$B$2,CONCATENATE("Out"," - ",C$1))[/TD]
[TD]Winner[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Bob[/TD]
[TD]=IF(ISERROR(VLOOKUP(C4,'Survivor Support'!$C$3:$C$34, 1, FALSE)),$B$2,CONCATENATE("Out"," - ",C$1))[/TD]
[TD]Loser[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Jane[/TD]
[TD]=IF(ISNA(VLOOKUP(C5,'Survivor Support'!$C$3:$C$34, 1, FALSE)),VLOOKUP(D5,'Survivor Support'!$G$3:$G$34, 1, FALSE),VLOOKUP(E5,'Survivor Support'!$K$3:$K$34, 1, FALSE))[/TD]
[TD]Winner[/TD]
[TD]Loser[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Sue[/TD]
[TD]=IF(ISNA(VLOOKUP(C6,'Survivor Support'!$C$3:$C$34, 1, FALSE)),VLOOKUP(D6,'Survivor Support'!$G$3:$G$34, 1, FALSE),VLOOKUP(E6,'Survivor Support'!$K$3:$K$34, 1, FALSE))[/TD]
[TD]Winner[/TD]
[TD]Winner[/TD]
[TD]Loser[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

So how do I extend this to check all 10 days of March Madness? Using the formula in B5 - I can get it to return "Loser" (I have not tried to do the cell reference yet to get it to return "In" our "Out - Day 2") - but since I can get it to return "Loser" I feel I can figure that out... However - using the same row 6 - gives me a "#N/A" return?

I am on Excel 2016 - but before the new functions came out - so I do not have IFS (thought that might be my answer)...

Is there an easier approach someone can think of - or if this is the right approach, any help on the formula would be appreciated.

Thanks,
Brian

 

[StephenCrump]

Welcome to the Forum!

I'm not sure what your other sheet looks like, but I think your formulae can be much simpler:

B5: =IFERROR("Out Day "&MATCH(TRUE,C5:F5<>C$2:F$2,),"Still in") Array entered

Book1
	A	B	C	D	E	F
1	Day		1	2	3	4
2	Result		A	B	A	A
3
4	Picks	Status
5	Bill	Out Day 2	A	A	A	A
6	Bob	Out Day 1	B	B	B	B
7	Jane	Out Day 4	A	B	A	B
8	Mary	Still in	A	B	A	A
Sheet1

 

[brianharg]

Welcome to the Forum!

I'm not sure what your other sheet looks like, but I think your formulae can be much simpler:

B5: =IFERROR("Out Day "&MATCH(TRUE,C5:F5<>C$2:F$2,),"Still in") Array entered

	A	B	C	D	E	F
Day
Result
Picks
Bill
Bob
Jane
Mary

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]Status[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]Out Day 2[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]Out Day 1[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]B[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]Out Day 4[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]Still in[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]

</tbody>

I am trying to play with this as it certainly seems a lot simpler! What do you mean by "array entered" at the end of the equation?

Maybe to try to be more clear (my bad!).... If you think about the NCAA Basketball tournament.. On day 1 the players (Bill, Bob, Jane, Mary) will each have to pick 1 team out of 32 - so I have that as one list/column in my other sheet. There will then be 16 losing teams which I will track as another column. So I need to see what Bill picked (C5) compared to the whole list of day 1 losers 9 (C2 above - but it will be a list C2 thru C17). Then again for day 2 (D5 compared to a list D2 thru D17). Then Day 3 - through 10. The fact I needed to look in a range is why I was thinking VLOOKUP? I have not used MATCH before, but trying to see if it will work.

 

[StephenCrump]

What do you mean by "array entered" at the end of the equation?

CTRL-Shift-Enter rather than Enter, i.e. type the formula, then instead of hitting the Enter key, first hold down the CTRL and Shift keys and then hit the Enter key.

Maybe to try to be more clear (my bad!)....

It would help if you could show screenshots of your data, and the results you're expecting to see.

Part B here gives you a couple of ways you can use to post screenshots: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

 

[brianharg]

OK - will do what I can - thanks for the patience with a newbie!!!

Here is the main Survivor Worksheet where they will pick the winner each day. I do have conditional formation working that shows the losers in yellow/red. Column B is what I am trying to get working.

Excel 2013 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

​

[/td][td]

In​

[/td][td]

Day 1​

[/td][td]

Day 2​

[/td][td]

Day 3​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

Player​

[/td][td]

Out​

[/td][td]

15-Mar​

[/td][td]

16-Mar​

[/td][td]

17-Mar​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

a 1​

[/td][td]

In​

[/td][td]

Rhode Island​

[/td][td]

Cincinnati​

[/td][td]

Rhode Island​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

a 2​

[/td][td]

In​

[/td][td]

Tennessee​

[/td][td]

Purdue​

[/td][td=bgcolor:#FFFF00]

Villanova​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

a 3​

[/td][td]

In​

[/td][td]

Gonzaga​

[/td][td=bgcolor:#FFFF00]

New Mexico State​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

b 1​

[/td][td]

Out - Day 1​

[/td][td=bgcolor:#FFFF00]

St. Bonaventure​

[/td][td]

North Carolina​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

b 2​

[/td][td]

Still in​

[/td][td=bgcolor:#FFFF00]

St. Bonaventure​

[/td][td]

​

[/td][td]

​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Survivor[/td][/tr][/table]

Here is the table again - but with the formulas... Using the Vlookup I can get the first day to work - but I do not know how to nest more lookups to get day2 , day 3, etc.

Excel 2013 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

​

[/td][td]

In​

[/td][td]

Day 1​

[/td][td]

Day 2​

[/td][td]

Day 3​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

Player​

[/td][td]

Out​

[/td][td]

15-Mar​

[/td][td]

16-Mar​

[/td][td]

17-Mar​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

a 1​

[/td][td]

=IF(ISERROR(VLOOKUP(C4,'Survivor Support'!$J$3:$J$34, 1, FALSE)),$B$2,CONCATENATE("Out"," - ",C$2))​

[/td][td]

Rhode Island​

[/td][td]

Cincinnati​

[/td][td]

Rhode Island​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

a 2​

[/td][td]

=IF(ISERROR(VLOOKUP(C5,'Survivor Support'!$J$3:$J$34, 1, FALSE)),$B$2,CONCATENATE("Out"," - ",C$2))​

[/td][td]

Tennessee​

[/td][td]

Purdue​

[/td][td=bgcolor:#FFFF00]

Villanova​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

a 3​

[/td][td]

=IF(ISERROR(VLOOKUP(C6,'Survivor Support'!$J$3:$J$34, 1, FALSE)),$B$2,CONCATENATE("Out"," - ",C$2))​

[/td][td]

Gonzaga​

[/td][td=bgcolor:#FFFF00]

New Mexico State​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

b 1​

[/td][td]

=IF(ISERROR(VLOOKUP(C7,'Survivor Support'!$J$3:$J$34, 1, FALSE)),$B$2,CONCATENATE("Out"," - ",C$2))​

[/td][td=bgcolor:#FFFF00]

St. Bonaventure​

[/td][td]

North Carolina​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

b 2​

[/td][td]

=IFERROR("Out Day "&MATCH(TRUE,C8:F8<>'Survivor Support'!J3:J18,),"Still in")​

[/td][td=bgcolor:#FFFF00]

St. Bonaventure​

[/td][td]

​

[/td][td]

​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Survivor[/td][/tr][/table]

Here is the reference sheet. First several columns (a thru H) will be all the teams that will play that day - that I will extend for 10 days. Then the next set of columns is where I was going to list the losers (I am using this for the conditional formation).

Excel 2013 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][th]

I​

[/th][th]

J​

[/th][th]

K​

[/th][th]

L​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]Day 1[/td][td][/td][td][/td][td]Day 2[/td][td][/td][td][/td][td]Day 3[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]Team[/td][td]seed[/td][td][/td][td]Team[/td][td]seed[/td][td][/td][td]Team[/td][td]seed[/td][td][/td][td]Day 1 Losers[/td][td]Day 2 Losers[/td][td]Day 3 Losers[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]Rhode Island[/td][td]

7​

[/td][td][/td][td]Texas A&M[/td][td]

7​

[/td][td][/td][td]Rhode Island[/td][td]

7​

[/td][td][/td][td]Oklahoma[/td][td]Pronidence[/td][td]Villanova[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]Tennessee[/td][td]

3​

[/td][td][/td][td]Purdue[/td][td]

2​

[/td][td][/td][td]Tennessee[/td][td]

3​

[/td][td][/td][td]Wright State[/td][td]Cal State Fullerton[/td][td]Kentucky[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]Gonzaga[/td][td]

4​

[/td][td][/td][td]Marshall[/td][td]

13​

[/td][td][/td][td]Gonzaga[/td][td]

4​

[/td][td][/td][td]UNCG[/td][td]Wichita State[/td][td]Houston[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]Kansas[/td][td]

1​

[/td][td][/td][td]Cincinnati[/td][td]

2​

[/td][td][/td][td]Kansas[/td][td]

1​

[/td][td][/td][td]Penn[/td][td]Georgia State[/td][td]Texas Tech[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]Duke[/td][td]

2​

[/td][td][/td][td]North Carolina[/td][td]

2​

[/td][td][/td][td]Duke[/td][td]

2​

[/td][td][/td][td]Iona[/td][td]Lipscomb[/td][td]Alabama[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]Loyola (Ill.)[/td][td]

11​

[/td][td][/td][td]Butler[/td][td]

10​

[/td][td][/td][td]Loyola (Ill.)[/td][td]

11​

[/td][td][/td][td]Miami[/td][td]Arkansas[/td][td]Buffalo[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]Ohio State[/td][td]

5​

[/td][td][/td][td]West Virginia[/td][td]

5​

[/td][td][/td][td]Ohio State[/td][td]

5​

[/td][td][/td][td]South Dakota State[/td][td]Murray State[/td][td]Michigan[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td]Seton Hall[/td][td]

8​

[/td][td][/td][td]Nevada[/td][td]

7​

[/td][td][/td][td]Seton Hall[/td][td]

8​

[/td][td][/td][td]N.C. State[/td][td]Texas[/td][td]Florida[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td]Villanova[/td][td]

1​

[/td][td][/td][td]Kansas State[/td][td]

9​

[/td][td][/td][td]Villanova[/td][td]

1​

[/td][td][/td][td]Radford[/td][td]Creighton[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

12​

[/td][td]Kentucky[/td][td]

5​

[/td][td][/td][td]Michigan State[/td][td]

3​

[/td][td][/td][td]Kentucky[/td][td]

5​

[/td][td][/td][td]Davidson[/td][td]Bucknell[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

13​

[/td][td]Houston[/td][td]

6​

[/td][td][/td][td]Xavier[/td][td]

1​

[/td][td][/td][td]Houston[/td][td]

6​

[/td][td][/td][td]San Diego State[/td][td]Texas Southern[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

14​

[/td][td]Texas Tech[/td][td]

3​

[/td][td][/td][td]Auburn[/td][td]

4​

[/td][td][/td][td]Texas Tech[/td][td]

3​

[/td][td][/td][td]Stephen F. Austin[/td][td]Charleston[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

15​

[/td][td]Alabama[/td][td]

9​

[/td][td][/td][td]UMBC[/td][td]

16​

[/td][td][/td][td]Alabama[/td][td]

9​

[/td][td][/td][td]Virginia Tech[/td][td]Virginia[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

16​

[/td][td]Buffalo[/td][td]

13​

[/td][td][/td][td]Syracuse[/td][td]

11​

[/td][td][/td][td]Buffalo[/td][td]

13​

[/td][td][/td][td]Arizona[/td][td]TCU[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

17​

[/td][td]Michigan[/td][td]

3​

[/td][td][/td][td]Florida State[/td][td]

9​

[/td][td][/td][td]Michigan[/td][td]

3​

[/td][td][/td][td]Montana[/td][td]Missouri[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

18​

[/td][td]Florida[/td][td]

6​

[/td][td][/td][td]Clemson[/td][td]

5​

[/td][td][/td][td]Florida[/td][td]

6​

[/td][td][/td][td]St. Bonaventure[/td][td]New Mexico State[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

19​

[/td][td]Oklahoma[/td][td]

10​

[/td][td][/td][td]Pronidence[/td][td]

10​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

20​

[/td][td]Wright State[/td][td]

14​

[/td][td][/td][td]Cal State Fullerton[/td][td]

15​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

21​

[/td][td]UNCG[/td][td]

13​

[/td][td][/td][td]Wichita State[/td][td]

4​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

22​

[/td][td]Penn[/td][td]

16​

[/td][td][/td][td]Georgia State[/td][td]

15​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

23​

[/td][td]Iona[/td][td]

15​

[/td][td][/td][td]Lipscomb[/td][td]

15​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

24​

[/td][td]Miami[/td][td]

6​

[/td][td][/td][td]Arkansas[/td][td]

7​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

25​

[/td][td]South Dakota State[/td][td]

12​

[/td][td][/td][td]Murray State[/td][td]

12​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Survivor Support[/td][/tr][/table]

Am I way off base on how I am trying to get this to work? If there something simpler that I am not thinking of? I have read I can only nest 7 statements - will this be a problem w/ the need for 10 days?

 

[StephenCrump]

C2 conditionally formatted with formula: =ISNUMBER(MATCH(C2,G$2:G$20,))

B2: =IFERROR("Out day " &1/(1/MIN(IF(C2:E2=G$2:I$20,COLUMN(G2:I2)-COLUMN(G2)+1))),"Still in") Array-entered

Book1
	A	B	C	D	E	F	G	H	I
1	Player	In/Out	Day 1	Day 2	Day 3		Day 1 Losers	Day 2 Losers	Day 3 Losers
2	a 1	Still in	Rhode Island	Cincinnati	Rhode Island		Oklahoma	Pronidence	Villanova
3	a 2	Out day 3	Tennessee	Purdue	Villanova		Wright State	Cal State Fullerton	Kentucky
4	a 3	Out day 2	Gonzaga	New Mexico State			UNCG	Wichita State	Houston
5	b 1	Out day 1	St. Bonaventure	North Carolina			Penn	Georgia State	Texas Tech
6	b 2	Out day 1	St. Bonaventure				Iona	Lipscomb	Alabama
7							Miami	Arkansas	Buffalo
8							South Dakota State	Murray State	Michigan
9							N.C. State	Texas	Florida
10							Radford	Creighton
11							Davidson	Bucknell
12							San Diego State	Texas Southern
13							Stephen F. Austin	Charleston
14							Virginia Tech	Virginia
15							Arizona	TCU
16							Montana	Missouri
17							St. Bonaventure	New Mexico State
Sheet1

 

[brianharg]

Seems to be working GREAT! Thank you so much

 

[StephenCrump]

Great! You're welcome.

You should probably also validate the players' choices against some master list to make sure you have exact matches.

If, for example, I chose Maimi, Tennassee and Oklahamo as my winners, I'd be pretty confident these choices wouldn't appear on your list of losers.

More subtly, any leading, trailing or intermediate spaces would also prevent an exact match.

 

[brianharg]

Thanks and great idea! I am using the "Survivor Support" tab to create a drop down list they have to select from. Column A for day 1, Column D for day 2 and so on. I am running an easier pool now and learned that the hard way! Types, spaces, etc. can kill me!