this post was submitted on 30 Apr 2024
130 points (98.5% liked)

Vanity license plates

363 readers
1 users here now

A place to post pictures of vanity and customized license plates that you see around town. For more info, check out this Wikipedia page.

Rules:

founded 1 year ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 24 points 4 months ago (3 children)
[–] [email protected] 12 points 4 months ago (3 children)

I've been a loyal adherent of the great INDEX(MATCH) for years, but I will have to look at this XLOOKUP deity to see if I should convert.

[–] [email protected] 6 points 4 months ago (1 children)

FILTER is another of the more recent excel functions that is also really awesome

[–] [email protected] 5 points 4 months ago

I use FILTER and XLOOKUP on the daily

[–] [email protected] 2 points 4 months ago

I know that XLOOKUP is probably better, but I just like my lil INDEX(MATCH) for some reason. You couldn't pay me to convert (you probably could)

[–] [email protected] 2 points 4 months ago

Sad, that's what they taught us in college ~2017 but XLOOKUP is just that but better and less typing

[–] [email protected] 5 points 4 months ago* (last edited 4 months ago)

INDEX(MATCH)

It’s clunky but the best without bricking older Excel users

[–] Deadeyegai 3 points 4 months ago

Fuck yeah it is. Even better than the tried and tested INDEX MATCH combo