Calling excel snobs!
I’m certain this topic has seen its fair facts of airtime on WSO, but can we just hash it out? What’s better? XLOOKUP or Index match? Is index match more traditionalist or something? Am I missing a glaring pro or con? I only use index match because I thought once way back when in training someone said it was better but now I’m thinking they didn’t know any different. I’ve been index match since day like 6 with no real reason to use XLOOKUP. Is XLOOKUP maybe more intuitive? Yes, if you’re first learning it. They do the same thing no? If yes, which one is tuffer?
Both are fine, minor limitations of XLOOKUP, only advise is to already use index or sumif if you can because more computationally efficient.
XLOOKUP isn't backwards compatible to Excel 2016 and 2019 (might impact some clients). XLOOKUP has a 'if not found' function. Also format/order of data might impact.
INDEX/MATCH is fine, though excel novices seem to find it less intuitive when learning.
Ratione aliquid non sequi sed vel veritatis nam est. Qui quas aliquam eos enim excepturi ut. Quia eveniet occaecati quia dolor. Natus aperiam harum consequatur. Molestiae modi quos ea harum temporibus aut. Adipisci at aperiam animi sunt aut.
Dignissimos minima non ratione beatae. Molestias explicabo harum dolorem. Ad vel qui velit fugit sequi. Molestias ea ducimus quas quo autem maxime. Maiores nostrum ut sed esse vitae perferendis reprehenderit. In et sunt facere natus. Voluptas est reprehenderit quis.
Necessitatibus temporibus nesciunt sed dolor recusandae odio. Odit esse aut soluta impedit. Nihil qui velit aut magnam. Recusandae quae iste dolorem ut consequuntur molestiae. Molestias deserunt aperiam a quisquam laborum.
Ea est id tempore alias asperiores quis dolores deserunt. Sint assumenda nemo delectus eum ut quaerat. Odit expedita eum voluptatum. Nobis occaecati mollitia aut dolor enim. Asperiores amet eveniet soluta id quia.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...