Tag Archives: 2019

XLOOKUP vs VLOOKUP

XLOOKUP vs VLOOKUP

xlookup vs vlookup

Forget about the VLOOKUP function. The new XLOOKUP function has arrived, being a genuine alternative for VLOOKUP, HLOOKUP, INDEX and MATCH. If you know how to use the XLOOKUP function, you will never bother to use VLOOKUP anymore. The new feature, which has been recently introduced, has more options and is characterised by its flexibility, efficiency and user-friendliness.

XLOOKUP has six arguments:

= XLOOKUP ( Lookup_Value , Lookup_Array , Return_Array , If_not_Found , Match_Mode , Search_Mode )​​

1. Lookup_Value
2. Lookup_Array
3. Return_Array
4. If_not_Found
5. [Match_Mode] – default FALSE – Exact match
6. [Search_Mode] – default TRUE – Fist to last

Benefits of XLOOKUP over VLOOKUP:
✅ the searched result in the column may be placed to the left of the column with the searched value;

✅ change of the structure of the table with data by inserting or removing columns will not affect the result;

✅ we select only relevant ranges and not necessarily the entire table;

✅ it can return a range, not just a value;

✅ it can return a value, if not found;

✅ the exact search is set to 0 by default in argument 4, the most commonly used option;

✅ it can return the nearest higher value if we declare (1) in the 4th argument;

✅ should we look for the closest value in the 4th argument we do not need to have any data sorted;

✅ wildcard support only if you declare (2) in the 4th argument;

✅ it can search for the last value (-1) in argument 5;

✅ it carries out binary search;

✅ it performs searches not only vertically, but also horizontally if we mark the ranges accordingly;

✅ faster functionality.

You can learn similar issues and tricks at my comprehensive Excel Training in London.

Premier League Sweepstakes Excel spreadsheet

Premier League Sweepstakes Excel spreadsheet

Premier League Sweepstakes is an Excel spreadsheet file created for season 2018 -2019. It allows bunch of people to run sweepstakes or office pool based on the outcomes of the matches and is fully automated. You can select interesting  teams and trace their trend.

Excel Premier League
Premier League Sweepstakes Excel spreadsheet contains worksheets:

  • Instruction – User manual and description
  • Schedule – Schedule matches, results and sweepstakes (manual parts)
  • Tables – Premier League Tables (Fully automated)
  • Players – Sweepstakes Players table and visualisation by round (Fully automated)
  • SET – Settings teams and calculates points for selected teams.

Sweepstakes rules

If contestant predicted exact result 3 points
If contestant predicted the winner of the match or a draw 1 point However, you are the owner of version PRO so you can easily change the number of points in worksheet SET and you can define different points for a different round.

FREE Premier League 2018-2019 Sweepstakes Excel spreadsheet download

Please feel free to download Premier League 2018-2019 Sweepstakes. It does not require any additional software or any registration and it is also free of VBA code. Just push the button below, save the file and enjoy supporting your team and keep calm during the contest if it is possible.

Download Free

Advanced version PRO

If you are interested in buying an advanced version of Premier League 2019-20 PRO, Sweepstake for 50 players, not protected by password, therefore you have a special access to advanced functions and methods used in this spreadsheet including easy settings point by round, please click button below Buy Now.