Kevin Stratvert
Region: US
Sunday 06 October 2024 07:00:00 GMT
846316
27900
148
2211
Music
Download
Comments
Grotti :
Xlookup is better
2024-11-20 20:18:31
21
Pcool :
how do i get my brain to memorize all these formulas🤦🏻♀️
2024-10-18 07:03:05
9
AA :
Use python
2024-12-19 09:23:58
0
Richard Nutt :
Is this 1990
2024-10-06 16:10:45
8
That girl :
What if I have the data in a separate sheet?
2024-10-28 06:57:24
1
Khalid :
Centrol F is more easier
2024-12-14 21:29:36
6
Stoney2times :
Step one: do an Index/Match.
2024-10-11 04:56:23
6
Real Jasper :
xlookup makes vlookup look like an ancient man
2024-10-06 07:34:41
233
SirFatuousPauper 🇬🇧 :
Vllookup one sentence: use xlookup instead.
2024-10-15 15:42:24
43
light_upon_light :
but there price is already there in the table, why are u looking it up
2024-10-12 18:05:22
1
Becca Hostilo :
In my 10+years of excel, I’ve never had vlookup click for me. Think this finally made it make sense! Thanks so much.
2024-10-09 15:16:54
60
Nabi :
Can I use this if I have the table in other file? Like from one file that sent me on my email to a new file on excel?
2025-03-19 19:27:55
0
endriu :
If you dont freeze the selected array within the formula with F4 it will move down and mess up the search as you drag it over the other cells so keep that in mind guys
2024-12-07 10:48:20
2
Daffa :
Thankyou
2025-01-02 04:05:15
0
jacqueline kahigi :
like
2025-02-25 15:26:11
0
M :
Just use xlookup
2025-01-03 06:11:47
0
Jimmy🦅 :
I've been following you for years and if making sense could be a person, that would be you. thanks for the great efforst 👍
2024-12-17 04:58:51
0
zac :
One more important note for VLOOKUP is that it only reads to the right of column one, so your return array must always be to the right! Column 1 should be the table array, and following is is where
2024-11-03 08:38:26
0
njc959 :
People that say they use Xlookup thinking they are better but not realising there are times where lookup is better because it is a faster formula for the desired result
2024-12-25 00:23:16
0
N A :
Xlookup always
2024-12-17 02:47:11
0
yefryrt30 :
What if the tables have different formats. This can disrupt V- H- and X-lookups.
2024-12-20 18:06:56
0
The Pickerings :
ChatGPT does this for me now
2024-12-14 07:11:55
0
John Z 🇨🇦 :
Use XLookup. It’s much easier.
2024-12-18 20:42:51
0
N :
Excel and Microsoft word
2024-11-08 01:52:48
0
To see more videos from user @kevinstratvert, please go to the Tikwm
homepage.
