XLOOKUP vs. VLOOKUP - Head to head battle for speed!
Head to head XLOOKUP vs VLOOKUP function.
10 Million lookups (1 million at a time)
Timecodes:
0:00 Intro
0:11 =XLOOKUP(L2, $A$2:$A$1000001, $A$2:$A$1000001)
0:26 =VLOOKUP(L2, $A$2:$A$1000001,1,FALSE)
0:40 =XLOOKUP(L2:L1000001,A2:A1000001, A2:A1000001)
0:57 =VLOOKUP(L2:L1000001,A2:A1000001, 1, FALSE)
1:10 =XLOOKUP(L2:L1000001, SORT(A2:A1000001,1,1), SORT(A2:A1000001,1,1),,0,2)
1:34 =VLOOKUP(L2:L1000001, SORT(A2:A1000001,1,1),1,TRUE)
1:51 =LET(R, SORT(A2:A1000001,1,1),XLOOKUP(L2:L1000001, R, R,,0,2))
2:08 =LOOKUP(L2:L1000001, SORT(A2:A1000001,1,1))
Music from #Uppbeat (free for Creators!):
https://uppbeat.io/t/matrika/overdrive
License code: NIGJJJOKT8C2SMY4
Visit our business homepage: https://mycostpro.com
Watch video XLOOKUP vs. VLOOKUP - Head to head battle for speed! online without registration, duration hours minute second in high quality. This video was added by user Excel 101 19 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 531 once and liked it 17 people.