STOP USING XLOOKUP WRONG! Deep dive into XLOOKUP performance on Excel 365
Optimize your XLOOKUP performance by utilizing a range for your lookup value.
Timecodes:
0:00 - Intro
0:25 - The difference between methods
1:04 - Test result 1 - XLOOKUP w/ single cell lookup value
1:32 - Test result 2 - XLOOKUP w/ single cell lookup value, Binary search
1:56 - Test result 3 - XLOOKUP w/ range lookup value
2:10 - Test result 4 - XLOOKUP w/ range lookup value, Binary search
Visit our business homepage: https://mycostpro.com