Pros: Easy installation; matches Microsoft’s syntax exactly.
=XLOOKUP_VBA("ProductA", A2:A100, B2:B100, "Not found") xlookup add in download for excel 2010 free download
Test: Type =XLOOKUP( into a cell. If the tooltip appears, you are successful. Important Compatibility Notes Pros: Easy installation