=XLOOKUP(E2, A2:A1000, B2:B1000, "Not found")
At the bottom of the General tab, look for the warning. Check the Unblock box and click Apply . Step 3: Install the Add-In in Excel 2010 Open Excel 2010. xlookup add in download for excel 2010 free download
=INDEX(return_range, MATCH(lookup_value, lookup_range, 0)) =XLOOKUP(E2, A2:A1000, B2:B1000, "Not found") At the bottom