I don’t know what’s worse: the fact TikTok thought I’d be the type of person who’d enjoy getting countless random excel tips on their FYP, or the fact they were absolutely correct
2024-10-05 20:30:12
160
Don :
Naah, lemme stick to xlookup😂
2024-09-24 16:55:19
122
smc120354wk :
Literally just make it a table and filter that way.
2024-10-20 17:07:45
1
Denis Bernier525 :
I love xlookup
2024-10-06 03:43:44
0
Ahmad Afridi :
use filter option,simple!
2024-10-23 02:27:25
1
dkw999_ :
yeah no thanks
2024-10-25 20:00:40
0
mohamee :
great
2024-10-25 01:58:41
0
N_Mgreat :
F4 didn't work with me why it didn't lock the range
2024-10-16 09:49:35
0
Holy Bible :
nice
2024-10-25 16:07:39
0
Patrick Rutherford70 :
The D functions are old but don't work as well as they did in Lotus 123. Yeah I have been doing spreadsheets for a long time. Now I forgot why I used index match instead of dget.
2024-10-18 19:01:44
1
Dreamatnight :
The F4 trick is the biggest thing I’m taking away here
2024-12-11 18:55:20
0
Nananana :
Why not just filter?
2024-10-27 00:20:54
0
hafiz_azman_ :
is it possible to do bank reconciliation using excel
2024-10-30 10:54:57
0
Alyce Jackson :
Does it work on cells with more than 250 characters?
2024-11-20 03:06:32
0
prettywittysnow :
is it possible to have 2 criteria?
2024-10-27 17:33:58
0
Ayu Ana Sari :
if there is 2 criteria, can we?
2024-11-02 13:46:51
0
booniehat_ :
wanye kest is wild
2024-11-03 22:55:45
0
brainy :
before i even learn v lookup 😂
2024-10-24 14:54:51
0
J :
Xlookup the best
2024-10-19 02:01:53
0
2¢ | TwoScents :
wait how did u have the drop down on the ID?
2024-10-19 15:17:37
0
Ammar Ameen :
Kim Kardashian 😂
2025-12-20 10:41:33
0
😁 :
doesn't work for me😏
2024-12-05 21:35:47
0
peacebythewater1 :
I need your classes
2024-10-20 04:12:58
0
Gema the leggy potato :
Could you use the name column with a partial name or is it limited to exact match?
2024-10-19 22:03:29
0
Joshua :
Xloookup is usually more versatile
2024-10-06 13:02:33
0
To see more videos from user @cheatsheets, please go to the Tikwm
homepage.