Need Help :-(

[bboy]

Hi All,

Im having issues and its sending my head crazy lol.

I need a Vlook up to check if a player has played one of the below events (the list of names would be on a separate tabs under each event name which i have already set) and it to return a yes or a no. Then i need the consecutive column to return the amount of consectutive tournaments the player has participated in. Then i need the Expected prize column to check a seperate table for example - if the player plays 4 consecutive events they win 1 token.

<TABLE style="WIDTH: 677pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=902><COLGROUP><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width=90><COL style="WIDTH: 48pt" span=8 width=64><COL style="WIDTH: 140pt; mso-width-source: userset; mso-width-alt: 6838" width=187><COL style="WIDTH: 85pt; mso-width-source: userset; mso-width-alt: 4132" width=113><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 68pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; HEIGHT: 15pt; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" height=20 width=90>Nicknames</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event1</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event2</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event3</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event4</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event5</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event6</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event7</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event8</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 140pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=187>Consecutive Tournaments</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 85pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: #e2e2e2; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=113>Expected Prize</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" height=20>Player1</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" align=right>0</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" align=right>0</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" align=right>0</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" align=right>0</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" align=right>0</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" align=right>0</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" align=right>0</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" align=right>0</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none"></TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: #e2e2e2; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none"></TD></TR></TBODY></TABLE>

can any one help me on this or point me in the right direction? Please let me know if you need further info

 

[Gerald Higgins]

Can you give us maybe 3 examples of players, with typical data, different data for each player, so we know what results should be produced ?

 

[bboy]

Well I created 8 tabs. These tabs will have a list of players on each so I need to check if each player in the main tab( example above ) has played. So it should return a yes or no. Then to count how many consecutive events they have played by count all the yes in a row

 

[Gerald Higgins]

Same question again

Can you give us maybe 3 examples of players, with typical data, different data for each player, so we know what results should be produced ?

 

[bboy]

Should look like this once its checked the 8 different tabs i have set up

<TABLE style="WIDTH: 592pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=789><COLGROUP><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width=90><COL style="WIDTH: 48pt" span=8 width=64><COL style="WIDTH: 140pt; mso-width-source: userset; mso-width-alt: 6838" width=187><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 68pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; HEIGHT: 15pt; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" height=20 width=90>Nicknames</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event1</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event2</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event3</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event4</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event5</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event6</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event7</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 48pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=64>Event8</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #e2e2e2; WIDTH: 140pt; FONT-FAMILY: Calibri; BACKGROUND: #4f81bd; COLOR: white; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 700; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #4F81BD none" width=187>Consecutive Tournaments</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" height=20>Player1</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">no</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">no</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">no</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" align=right>3</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" height=20>Player2</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none">no</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none">no</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #dbe5f1; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" align=right>4</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; HEIGHT: 15pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" height=20>Player3</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">no</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">no</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">no</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">no</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none">yes</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #e2e2e2; FONT-FAMILY: Calibri; BACKGROUND: #b8cce4; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #e2e2e2; FONT-WEIGHT: 400; BORDER-RIGHT: white 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #B8CCE4 none" align=right>4</TD></TR></TBODY></TABLE>

Does that make sense?

So if player 1 has played Event1 his nickname will be on the first tab and so it returns a yes.

 

[P_Guru]

4 Consecutive tournaments = 1 token

5 consecutive tournaments = 2 tokens?

or

8 consecutive tournaments = 2 tokens?

 

[P_Guru]

=VLOOKUP("Player 1",TABLE,Event number+1,False)

 

[Gerald Higgins]

For the vlookup, maybe this

=if(iserror(vlookup(A2,Event1!A1:A10,1,false)),"NO","YES")

Assumptions
1) The player's names are held in Col A, starting at row 2, on the summary sheet.
2) The tabs for each event are called Event1 and so on
3) The names of players who played in Event1 are held in the range A1:A10 on the relevant sheet.

Adapt as required.

Does this work for the lookup part ?

 

[bboy]

I worked out how to show the tokens in the end, So it just looking up the players names from the other tabs which i have named EVENT1 - 8 (in name manager) And working out the consecutive number of events played

 

[bboy]

For the vlookup, maybe this

=if(iserror(vlookup(A2,Event1!A1:A10,1,false)),"NO","YES")

Assumptions
1) The player's names are held in Col A, starting at row 2, on the summary sheet.
2) The tabs for each event are called Event1 and so on
3) The names of players who played in Event1 are held in the range A1:A10 on the relevant sheet.

Adapt as required.

Does this work for the lookup part ?

Yep thats awesome it worked, Now just the consecutive amounts of yes