@setupspawn: Impress your boss with VLookup and XLookup in excel #excel #microsoftexcel #exceltips

Matty McTech
Matty McTech
Open In TikTok:
Region: US
Thursday 31 October 2024 20:53:29 GMT
127401
4550
54
190

Music

Download

Comments

chaosgrin
ChaosGrin :
Lookups only find the first instance unless you include an offset, dups are ignored. Great content! 🤝🤓
2024-10-31 21:07:24
2
luvhugz
Hugz :
thanks so much...... appreciate you.
2024-12-07 08:33:43
0
jeremy.c77
Jeremy Covey :
xlookup does the same job and is easier to
2024-12-29 00:08:39
1
silenzio1976
Alioscia :
I use Index -match is a better solution
2024-11-12 19:47:04
0
mayaaaaaabb
mayaaaaaabb :
You just gave the best explanation of vlookup I’ve seen. This is for you: 🏆🏆🏆
2024-10-31 21:01:29
6
ivielanie.m
deez ⛳️ putts :
Willem Dafriend is also Willem Myfriend
2024-10-31 21:27:40
4
denis05002
denis0500 :
Using vlookup, what your looking up doesn’t need to be in the left most column in the table it just needs to be in the first column you start your selection with, so using your data you could use vlookup to look for the salary and return the ID by just selecting columns C and D
2024-11-01 03:45:32
3
appleuser99973211
User999732 :
Which was the website to generate a presentation based on text input? Thank you!
2024-11-25 10:20:27
0
pcnyc1
pcnyc :
thanks, Matty! now how about those pivot tables?
2024-11-04 05:43:19
3
broken_spatulas
aJaX :
Those names are incredible🤣
2024-11-13 11:05:54
1
tiffany_whisenhunt
Tiffany W :
Vlookup is a life saver!
2024-11-02 23:15:33
1
rgm6170
RGM :
Do not need to use true or false, use 1 (true) or 0 (false).
2024-11-16 10:18:41
1
irishguy3
Irish Guy 🇨🇦 :
I love these videos. I use this stuff once every 2 months and I can never remember it. Haha. Thank you !
2024-11-02 15:35:30
1
keepgrowing770
Trֻuth🎗️ :
Love the employ names
2024-10-31 21:03:27
0
lisa_smith1964
L Smith 🇨🇦 :
Really need a magic excel ai tool
2024-11-27 02:01:07
0
umumumumuu
um :
guys do you know a way which i can use office programs for free without pico
2024-10-31 23:13:02
0
jyoung2gu
J Young :
I like index match over vlookup but I use Google sheets so it may throw a wrench in things
2024-11-20 02:10:28
0
vivienoribhabor
Vee_Tech :
Thanks for sharing this 💜
2025-01-06 12:03:32
0
alexandreraymond1
Alexandre Raymond :
does it work on Google sheets?
2024-11-02 13:13:26
0
johnathantheguy12
JohnathanThePersonGuy :
I thought i was gonna he first
2024-10-31 21:04:53
0
biskit81
Biskit :
well explained video. went slow enough to be able to follow along as well. this is how I need these videos.
2024-10-31 21:04:54
0
tover79
Roberto 79 :
There’s too much too know - I’ll take a pass
2024-11-01 03:39:07
0
storm.breeze
Stormy & Breezy :
IT is underpaid
2024-11-12 20:31:52
0
oliverthrone
OT :
I love excel so much
2024-11-02 10:16:25
0
To see more videos from user @setupspawn, please go to the Tikwm homepage.

Other Videos


About