Lookups only find the first instance unless you include an offset, dups are ignored. Great content! 🤝🤓
2024-10-31 21:07:24
2
Vee_Tech :
Thanks for sharing this 💜
2025-01-06 12:03:32
0
Jeremy Covey :
xlookup does the same job and is easier to
2024-12-29 00:08:39
1
merf :
You just gave the best explanation of vlookup I’ve seen. This is for you: 🏆🏆🏆
2024-10-31 21:01:29
6
Alioscia :
I use Index -match is a better solution
2024-11-12 19:47:04
0
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
pcnyc :
thanks, Matty! now how about those pivot tables?
2024-11-04 05:43:19
3
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
deez ⛳️ putts :
Willem Dafriend is also Willem Myfriend
2024-10-31 21:27:40
4
RGM :
Do not need to use true or false, use 1 (true) or 0 (false).
2024-11-16 10:18:41
1
aJaX :
Those names are incredible🤣
2024-11-13 11:05:54
1
Tiffany W :
Vlookup is a life saver!
2024-11-02 23:15:33
1
L Smith 🇨🇦 :
Really need a magic excel ai tool
2024-11-27 02:01:07
0
Trֻuth🎗️ :
Love the employ names
2024-10-31 21:03:27
0
JohnathanThePersonGuy :
I thought i was gonna he first
2024-10-31 21:04:53
0
Alexandre Raymond :
does it work on Google sheets?
2024-11-02 13:13:26
0
Oliver Throne I :
I love excel so much
2024-11-02 10:16:25
0
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
um :
guys do you know a way which i can use office programs for free without pico
2024-10-31 23:13:02
0
The Enlightened Introvert 愛する :
Nice
2024-11-07 14:56:20
0
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
lujio.13 :
Gracias
2024-11-25 17:51:06
0
To see more videos from user @setupspawn, please go to the Tikwm
homepage.