Here is where the magic of VBA (Virtual Basic for Applications) comes in. It's an undiscovered Excel feature for creating custom functions, which has entirely changed how I handle my spreadsheets.

You can create custom Excel functions using VBA matching using your criteria. Create custom Excel functions using Macros in Excel & use user-defined functions in Excel.