A lot of people work with VLOOKUP. However, it has some limitations. Most of the limitations can be resolved with using INDEX MATCH instead.
Category: Technology
Why Google Sheets Cannot Replace Excel
Among the Excel features that I like include Tables and easy date filtering.
One user, sethsn wrote the benefits of Excel at an online forum:
- It automatically populates the formula throughout the table – and continues to do so as you extend the table
- It automatically moves cells below the table down to make room for new roles
- You refer to columns by name rather than address which hugely improves readability as well as obviating the need to use absolute references
- It enables autofilter on each column and allows several columns to have filters on them
- The table can be referenced as a unit when used, say, as input to a pivot table
- It automatically formats the tables with alternating row colors to aid readability
- It allows you to total columns by name from outside the table (which, in turn, ensures that your total references the entire table no matter how many rows are added
Sources
Colour Codes
Color codes
Malaysian Flag: Malaysia flag color codes
Guides
Tools