I've gone for the default values for arguments e and f because I want an exact match, and I want Excel to search from the top of the lookup array (more on these later). In this example ...

While using Microsoft Excel for data analysis, you may sometimes need to search for and retrieve specific values. In such ...