Bowling league

First of all hello everybody.

Second the problem.

I am trying to create a bowling spreadsheet in Excel2003. This is for Crown Green Bowling rather then the 10 pin sort.

The way that the sheet works is that I enter the names of each player in the home and away sides then enter the score that each player has scored.

What I then want it to do is fill in the bottom part of the sheet which is the players league table this show the players name, games played, won games , lost games, score for, score against, the aggregate, and won, lost or not playing.

The bottom section uses the top part data to automatical fill in.
At the moment I have the top part working fine, although the bottom part of the sheet is proving a bit harder, I've tried using the Lookup formula, but this will only work if the team is always in alphabetical order.

I hope that you can understan what am on about (probably not), if anyone help that would be most weclome. I think I just need to be able to search the top part of the sheet for the player and then take the relevent data.

Thanks in advance.

Originally Posted by mutant04

First of all hello everybody.

Second the problem.

I am trying to create a bowling spreadsheet in Excel2003. This is for Crown Green Bowling rather then the 10 pin sort.

The way that the sheet works is that I enter the names of each player in the home and away sides then enter the score that each player has scored.

What I then want it to do is fill in the bottom part of the sheet which is the players league table this show the players name, games played, won games , lost games, score for, score against, the aggregate, and won, lost or not playing.

The bottom section uses the top part data to automatical fill in.
At the moment I have the top part working fine, although the bottom part of the sheet is proving a bit harder, I've tried using the Lookup formula, but this will only work if the team is always in alphabetical order.

I hope that you can understan what am on about (probably not), if anyone help that would be most weclome. I think I just need to be able to search the top part of the sheet for the player and then take the relevent data.

Thanks in advance.

If you're referring to the VLOOKUP() function, then if you add the fourth optional parameter 'FALSE' you'll find that the lookup will work.

e.g. =VLOOKUP(TeamName,Table,2,False)

As you've found, if you leave out this 'False' parameter the list has to be sorted to allow if vlookup is to work.