Users generally find it reliable for basic lookups, though it may not support 100% of the dynamic array behaviors found in the latest Excel versions. How to Install
If you share your file with someone who doesn't have the add-in installed, their formulas will break and show a #NAME? error. xlookup add in download for excel 2010 free download
You can now use =XLOOKUP(value, lookup_range, return_range) in your cells. Traditional Alternatives Users generally find it reliable for basic lookups,