Kat: Chief Excel Officer
Region: US
Wednesday 13 July 2022 16:57:52 GMT
70444
2950
56
105
Music
Download
Comments
Rogue :
Thank you and great tip! But more importantly I appreciate that you have slowed down when giving us the explanation.
2022-07-13 17:21:31
14
Uncle Buck :
Or use tables 😏
2022-07-13 19:35:29
0
paulie102704 :
X lookup so don’t have to reference the column or row…
2022-08-12 16:40:57
0
KailorMoon :
the way you explained this! 🤯 Now I get it. thank you SO much!
2022-07-14 02:56:13
0
Artur Iwan 🇪🇺🇨🇿🇵🇱 :
use named ranges, they are so cool :)
2022-07-13 17:14:51
3
daves.not.here.man :
alright alright alright
2022-07-13 22:55:50
0
Dreadness :
I thought we’re meant to be using xlookup now 😞
2022-07-13 22:40:13
1
dany_aminos :
hi sweety Kat 🥰 I think we can use the xlookup function instead of vlookup for the $ just select the column header all the search area will selected
2022-07-29 19:30:33
0
snellim 🇺🇸 :
I’m pretty sure the most common mistake in excel my coworkers make merging cells. 😅🤣
2022-07-13 17:16:29
3
GodSoldier971 :
Use F4
2022-07-13 21:39:02
3
Greg Berryman :
Wow. Way too much talking.
2022-07-13 17:38:36
2
DS :
FN + F4 🤦🏻♂️it’s just F4! The FN key only exists in keyboards looking to add functionality to Function keys, but Excel recognizes F4 not FN+F4
2022-07-23 04:37:55
1
user5666544272034 :
xlookup is the new standard, v and hlookup are more obtuse, less flexible, and need more arguments to work
2022-07-21 03:51:28
1
ILikeHats :
Do you actually think this is making Excel more accessible? I know Excel and it confused the hell out of me.
2022-07-25 00:18:49
1
AdamL :
I thought just F4 would work, I've never tried function F4 and I've made plenty of absolute references, am I missing something with how I'm doing it?
2022-07-27 00:56:19
1
Dday25B :
why are you still using vlookup instead of xlookup
2022-07-18 23:37:42
1
Connor Smith :
I ALWAYS do this…. By accident though 😂
2022-07-13 17:09:20
1
Nǝןsou Ǝsʇɹɐpɐ :
😳 👏👏👏
2022-07-13 17:09:30
1
Obedient1 :
Just highlight the entire columns instead of just the table
2022-07-19 03:30:30
0
cat from the back :
Ur hot
2022-07-20 07:58:07
0
Kelly Windley :
Omg just heard you on the Expanded podcast gold!!! Looking forward to following all your tips!! Well done you 🥰 very inspiring 🦋🦋
2022-07-21 03:23:12
0
Ignite > Academic :
F4
2022-08-28 06:21:21
0
Jenna Eli :
love this style vid!
2022-07-22 17:22:47
0
none :
I never really use excel but you’re great
2022-07-17 23:52:53
0
Veezy P. :
Are you the one from the podcast with Lacy Phillips?
2022-07-23 03:43:26
0
BOSS :
Loved you
2022-07-24 02:34:44
0
Wanis :
Thanks! Will you please teach how to have this same effect by naming the array?
2022-07-25 00:02:40
0
CC-1013 “Bobcat” :
Gotta lock your range, yo.
2022-07-27 15:46:03
0
_mauve_monday_ :
OMG you are a genious, aaaand you can explain it 🎉🎉🎉🎉🎉
2022-07-28 20:36:29
0
Simeon Williams :
When all you wanted to try was the F4 key! 😅
2022-08-03 22:25:03
0
Murray Severn :
This why I try to name arrays whenever possible
2022-07-14 05:16:09
0
Joe from Delaware :
Lock and load. More cute dances please.
2022-07-13 17:24:16
0
K :
I’ve never thanked my luck until today. I started manual work because vlookup wasn’t working for me. Literally saved hours of my day! Thank you!
2022-07-13 17:32:02
0
Ben’s Bored at Work :
Vlookup? Not xlookup?
2022-07-14 01:29:51
0
Ian Baylis :
learned this the hardway
2022-07-14 02:40:23
0
doodie_on_da_flor :
It's like you know what you're doing 😁
2022-07-14 03:07:31
0
GaryMo :
F4
2022-07-14 03:10:04
0
Scott Elliott :
Do one explaining goal seek… or better still scenarios with multiple variables and outputs whilst naming all the fields
2022-07-17 19:19:09
0
@roacjo :
This happened to me this week!! Thank you!! 👏
2022-07-14 11:04:47
0
Muffer :
Where’s mom’s support at!!??
2022-07-15 03:53:34
0
Dingus :
can't stand the way you're spoon feeding the audience. nope. a simple "how to" will suffice
2022-07-15 06:21:17
0
Jeremiah :
So good to know! Thanks
2022-07-15 13:38:41
0
Luc :
nice tip
2022-07-16 09:42:59
0
Lori Shoemaker Breme :
I always forget the $’s. I also did not know about the shortcut. I appreciate that you slowed down to explain!
2022-07-16 12:38:12
0
WhoKnowsBoJo :
I use a join in a database so no “vlookup” needed! Stop using excel as a database!
2022-07-16 20:17:13
0
Scott Elliott :
Woah woah woah 🤯 WTF? No not the dollar sign - I mean still using VLOOKUP instead of XLOOKUP 😳😳😳😳😳
2022-07-17 19:16:50
0
To see more videos from user @miss.excel, please go to the Tikwm
homepage.
