vlookup errors

Training Index

World Cup Spreadsheets (Rugby World Cup)

 

    The next big World Cup is the World Cup Rugby 2011 to be held in New Zealand. We have created a spreadsheet to do all the league tables  WITHOUT using any VBA to rank the teams. We support South Africa but New Zealand must have a great chance on home soil. Personally I think that Australia may have youth on their side.

To see the online spreadsheet, or to get the 2011 Rugby World Cup Spreadsheet please follow this link

2011 Rugby World Cup - New Zealand- Spreadsheet

Feel free to   tell others about the page. If you find any errors please contact us at info@AuditExcel.co.za . Come back often to get the updated versions. If you have any features you want to see included, email us at info@AuditExcel.co.za and tell us what you want.

So nothing is really free. We provide Excel training both in South Africa and Internationally. See what we offer on the Live Excel Training page . If you are from other countries, learn Excel online at www.AuditExcel.com

DOWNLOAD SOCCER WORLD CUP 2010 SPREADSHEET v 6 for Computers (doesn't work on mobile phones)

This version will warn you if the scores you have chosen result in a dead heat in the group stages at which stage a coin toss (or in this case our calculation) decides the rankings. You may need to change some of your scores to get a more accurate ranking.

See version 9 for Excel Mobile friendly version below-

LEARN HOW TO DO THIS YOURSELF WITH ONLINE EXCEL TRAINING- www.AuditExcel.com

 

DOWNLOAD 2010 WORLD CUP SOCCER MOBILE SPREADSHEET v 9 for mobile phones (works on both computers and mobiles)

This is a very new version to accommodate Excel Mobile which has less functions than the full version of Excel. It works on our HTC phones, but please tell us if it works on your version of Excel Mobile. If you are using the full version of Excel rather download version 6 at the top of this page.

LEARN HOW TO DO THIS YOURSELF WITH ONLINE EXCEL TRAINING- www.AuditExcel.com

 

Good luck to all the teams playing in the various leagues especially Manchester United and Chelsea in England, Real Madrid and Barcelona in Spain and Inter Milan in Italy.

We plan to create a similar spreadsheet for the English Premier league this year as well as for the Super 14 Rugby and World Cup Rugby for next year. All feedback appreciated.

PS- below are some ideas on how you could create these spreadsheet. This training is also useful for any other sporting events e.g.   rugby spreadsheets.

 

Be aware that these video clips use Flash.  Click on the hyperlink and, depending on your connection speed, you may need to wait a few moments.

 

Title Price
 
Video Clip
(Windows Media Player)
Automatic sorting of a list
A clever way to have your soccer or football league tables automatically sort themselves based on the most recent results (with no macros!!).

In order to get this to work you need to know about the VLOOKUP and RANK functions which are shown below.

FREE

 

Automatic Sort

(5 min)

RANK Information      
Rank
The Rank function allows you to rank a selection of cells in ascending or descending order automatically. Easier than using complex IF functions to achieve the same goal. Particularly useful for sporting spreadsheets where you want to automatically know the placing after entering the results.
FREE
Rank
(5 min)
VLOOKUP Information      
VLOOKUP
Learn how to use the VLOOKUP function in Microsoft Excel. The VLOOKUP functions enables you to pull through various bits of information based on some reference point. So for the sporting spreadsheet once you know the order of the teams, you can pull through all the other relevant information e.g. wins, losses, draws, goals for and goals against.

 

FREE
Handling Large VLOOKUP tables
Once you have mastered VLOOKUP you may find that you use it for large datasets. The problem is that when you make changes to your spreadsheet you sometimes need to go through all the VLOOKUP cells and change the column reference. Learn how to avoid this!

 



FREE
Typical errors made when using VLOOKUP
As useful as the VLOOKUP function is, there is a significant risk of errors. Learn what you must watch for.

 


FREE
World Cup Soccer Spreadsheet
 

 

Quote of the page: Some people think football is a matter of life and death....I can assure them it is much more serious than that- Bill Shankly

 

Google
Web AuditExcel.co.za

Spreadsheet Professional is the world's favorite auditing add in. Find out more on the Spreadsheet Professional pages!!

Do you like what you see. Tell your friends. If you have a training co-ordinator at your organisation tell them that there is free excel training available at this site.

Don't like what you see. Tell us at training@AuditExcel.co.za .

Do you have suggestions of what you would like to see. Tell us at training@AuditExcel.co.za .

 

 

 

Home | Contact Us | Sitemap | Training | Sarbanes Oxley | Articles | Links | Blog