May 2023
9:38am, 18 May 2023
695 posts
EdJ
Have we ever had an Excel formulas DeathMatch?
May 2023
9:50am, 18 May 2023
145,698 posts
GregP
We have not, mainly because it's descend into a pitch battle between the index/match lot from the premiership and the non-league bullies from vlookup
May 2023
10:21am, 18 May 2023
40,550 posts
SPR
🤣🤣🤣
May 2023
11:21am, 18 May 2023
70,301 posts
GlennR
Spreadsheet Sunday cloggers.
May 2023
11:28am, 18 May 2023
40,551 posts
SPR
Vlookup is decent, but can it cut it on a rainy day in Stoke?
May 2023
11:48am, 18 May 2023
145,715 posts
GregP
It's okay going forwards...
May 2023
12:12pm, 18 May 2023
40,552 posts
SPR
A one trick pony...
May 2023
12:19pm, 18 May 2023
145,719 posts
GregP
It can't track backwards, it's painfully slow. People who's opinion is absolutely not to be trusted tell you it's a good solution to your needs... https://youtu.be/tjQeBj7KwVE
VIDEO
May 2023
12:19pm, 18 May 2023
7,402 posts
um
It's very much root / route 1. But quite effective against some of those fancier and more tactical approaches.
May 2023
12:21pm, 18 May 2023
145,721 posts
GregP
Whisper it quietly, but I use it in a hurry because I know the syntax without thinking. Index/Match takes much more engagement of brain.