Lookup Formula No Match - Excel Calculation Problem

In this video, we solve a calculation problem in Excel that results in our lookup formula returning no match. The #N/A error is returned despite there being what appears to be a matching value. In the video, the XLOOKUP function is used but this problem applies to all lookup formulas and stems from a calculation problem in Excel. The following timings are used in the video. 00:00 - XLOOKUP function not working 01:24 - Find the true number 02:12 - Fix with the ROUND function in Excel 03:05 - Why did the issue occur? 03:56 - Set precision as displayed option in Excel Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN