@cellmates_: 📹 Excel Tutorial | This VLOOKUP trick helps you return multiple values in one formula. 🔖 #excel #exceltricks #exceltips #learnexcel #microsoft365

Deb Ashby | Cellmates 🇬🇧
Deb Ashby | Cellmates 🇬🇧
Open In TikTok:
Region: GB
Thursday 15 October 2026 02:56:29 GMT
6414
277
19
43

Music

Download

Comments

rusty_cogs
Rusty Cogs :
I would use choosecols and filter
2026-10-15 16:44:50
0
robbie.lobby0
Robbie Lobby :
This looks really useful. I use Index Match so assume the same technique will work with that.
2026-10-15 09:31:30
0
mreagles
MrEagles :
I number the columns and refer it to the number. Done this since the 90's
2026-10-15 08:07:28
0
ged1471
Ged :
Excellent, had completely forgotten about the curly braces method 😁
2026-10-15 07:27:30
0
pinkrdchick
Granny Nicki :
I also love FILTER now, but I guess this would be better if you only wanted to return some of the columns
2026-10-15 07:36:25
1
ea_blair4
EA_Blair :
Wait, there is a keyboard shortcut to lock the cell references?!
2026-10-15 11:27:58
1
blunight7
🔱💎CHRIS💠👑 :
I use everyday X.LookUp and its fine
2026-10-15 05:36:48
2
flickclips
Flick Clips :
Very cool. I use this and also my new favorite Filter function.
2026-10-15 04:03:52
1
johnnymcvee1
Toughkneigh (Tony) :
this is awesome! I am just not sure what I will do with all the extra time on my hands as a result of using this 😁🤣
2026-10-15 03:10:03
2
anaionelastefan
Alina🖤 :
Data Validation is a time saver, amazing🥰. No more typing errors, and #ref, #name 🤌
2026-10-15 07:26:23
1
msinghduk
msinghduk :
👏👏👏
2026-10-15 03:50:35
1
To see more videos from user @cellmates_, please go to the Tikwm homepage.

Other Videos


About