@excel_with_kyle: Here is the #1 reason why you should use XLOOKUP or INDEX MATCH if you are still using VLOOKUP in Excel! The 3 main lookup functions are: XLOOKUP, INDEX MATCH, and VLOOKUP. In my opinion, VLOOKUP is by far the worst choice of the 3 for many reasons (I have lots more videos coming soon on all the reasons), but the main reason is that VLOOKUP can't return values to the left of your lookup array, which XLOOKUP and INDEX MATCH can #exceltips #dataanalytics #businessgrowth #spreadsheet #corporatelife #financetips #worksmarternotharder

Excel With Kyle
Excel With Kyle
Open In TikTok:
Region: US
Wednesday 21 January 2026 01:00:00 GMT
124509
3863
31
681

Music

Download

Comments

vidaaaa01
VG :
You can index the entire table and using 2 match formulas and can copy the formula to different columns and get the value having to never make another formula again. Index match is superior at the end of the day.
2026-03-11 23:38:22
1
blipt_the_first
Blipt_the_first :
Can’t you just use a negative column selection? I mean, I don’t use vlookup, but still….
2026-01-23 02:39:40
1
the.michigan.dietitian
The Michigan Dietitian :
I use I-look-up
2026-01-21 01:54:23
19
jakartasoo
JakartaSoo :
Love xlookup; watching my cfo use vlookup and asked him if he is familiar with Xlookup. He grumbled and I shrugged my shoulders. Okay do it the hard way. 😂😂😂
2026-02-01 18:06:45
12
comon.man2
Coman.man :
But can you use {2,3} feature in vlookup? That feature saves us from typing 2 or more formulas What do you think?
2026-01-24 15:11:11
3
kjt_1
kjt_1 :
Vlookup is goated for looking up ranges
2026-02-02 20:30:45
0
_number4_
Sam :
I used to use the look up to determine the quality of the candidate being hired. If they didn’t know how to use index match, I knew they were limited.
2026-01-22 05:49:07
1
yuppie2223
yuppie2223 :
yeah sounds good but xlookup on a huge file can slow down your workbook. 😭😭😭
2026-02-07 07:45:01
0
adamlaw65
Adam Law :
Slows everything down, so no 😁
2026-02-06 05:02:36
0
jimmylindhout
Jimmy Lindhout :
Leveling up my excel game💪
2026-01-21 02:54:26
1
moshoeneng
Muk :
You could use xlookup within the choosecols command and you would have to repeat it, no?
2026-02-16 11:52:58
0
nyc.bison
NYC Bison :
Built in if error function and default to exact match also who wants to count the number of columns.
2026-01-21 01:20:35
6
eiman23x
eiman23x :
nice, usually use vlookup, look xlookup is more simple
2026-02-07 12:34:42
0
diego2vanik
Ike de Español :
A single xlookup can actually return more than 1 column. Xlookup and filter function is the life saver
2026-02-24 21:18:12
0
altiti_14
AL :
Xlookup saves lives
2026-01-22 05:24:04
2
theescorpio17
Ponch :
Thank you!
2026-01-21 01:14:26
2
toribfloyd
ToriFloyd :
Thank you so much for this explanation!
2026-01-21 01:24:46
1
kylebloom22
Kyle :
😂😂😂
2026-01-23 01:34:08
0
alrickjacobs562
alrickjacobs562 :
😂😂😂
2026-03-03 20:37:52
0
mastermind_486
Royal & Loyal :
💐💐💐💐
2026-02-28 03:53:17
0
legenthereal
LegenTheReal :
😳😳😳
2026-03-03 19:02:38
0
i.carz
_itssicrz :
😂😂😂
2026-02-09 18:21:04
0
kmarie05019
Kmarie :
❤️❤️❤️
2026-03-07 14:12:40
0
jallen7174
BigPapa :
❤️❤️❤️
2026-03-11 13:23:14
0
donnaledoux1
DONNA LEDOUX :
😳😳😳
2026-01-22 05:52:41
0
To see more videos from user @excel_with_kyle, please go to the Tikwm homepage.

Other Videos


About