this post was submitted on 28 Aug 2023
695 points (97.7% liked)

Memes

45641 readers
1324 users here now

Rules:

  1. Be civil and nice.
  2. Try not to excessively repost, as a rule of thumb, wait at least 2 months to do it if you have to.

founded 5 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 37 points 1 year ago (2 children)

It's an INDEX() and MATCH() made in heaven!

[–] [email protected] 3 points 1 year ago

That sounds better than an xlookup.

[–] [email protected] 3 points 1 year ago

Gonna nest my IFs here