How to Return the Cell Address of a Match in Excel

In Excel, you might often need not just the value from a lookup, but also the exact cell address where that value is found. This is especially useful when you want to reference or highlight that cell ...