126
For all the corporate Excel jockeys out there (lemmy.world)
submitted 3 months ago by NeptuneOrbit@lemmy.world to c/vanitypl8s@lemmy.world
15 comments fedilink hide all child comments
top 15 comments
sorted by: hot top controversial new old
[-] florge@feddit.uk 24 points 3 months ago

XLOOKUP is where it's at.

[-] CuriousRefugee@lemmy.ml 12 points 3 months ago

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.

[-] florge@feddit.uk 6 points 3 months ago

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

[-] ShadowAndFlame@mander.xyz 5 points 3 months ago

I use FILTER and XLOOKUP on the daily

[-] LordPassionFruit@lemm.ee 2 points 3 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)

[-] ShadowAndFlame@mander.xyz 2 points 3 months ago

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

[-] Milk_Sheikh@lemm.ee 5 points 3 months ago* (last edited 3 months ago)

INDEX(MATCH)

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

[-] Deadeyegai@lemmy.world 3 points 3 months ago

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

[-] Signtist@lemm.ee 6 points 3 months ago

I only recently discovered this function, and it's been a lifesaver. I work in construction, going through big tables that outline all the doors in the project, and every once in awhile they put out an addendum that completely changes the order all the doors are listed in, adding new ones and changing bits and pieces along the way. It used to take me hours or even days of sorting to salvage the work I put in, getting it reorganized to fit the new table in the crappy construction spreadsheet program we have. Now I can just copy everything to excel, use vlookup, and reorder all my data to the new table in minutes!

[-] some_guy 3 points 3 months ago

I don't understand letting a dealership put an advertisement around your plate. A dealership tried to do that to my car when I brought it in for service. I made them take it off.

[-] Milk_Sheikh@lemm.ee 2 points 3 months ago

Flip it - put the trim piece behind your plate. Reduces some of the rattling and removes the sharp edge while also doing its job and keeping plastic out of a landfill

[-] NeptuneOrbit@lemmy.world 1 points 3 months ago

I definitely took it off when I moved and got new plates. Otherwise, I felt similarly but was too lazy to do it myself.

[-] Gork@lemm.ee 3 points 3 months ago

Index Match is superior in every way tho

[-] Deadeyegai@lemmy.world 11 points 3 months ago

And XLOOKUP is actually superior to INDEX MATCH. It even has an ERRORIF function baked into it! 😱

[-] Anticorp@lemmy.world 2 points 3 months ago

Dang, showing off their elite status with their Mazda, and their custom plate.

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

Vanity license plates

347 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
RoyalEngineering@lemmy.world