Xlookup making index-match obsolete destroys half my value proposition

likefunny
Posting as :
works at
You are currently posting as works at

sql inner join?

like

People refuse to learn index match. How are they gonna learn to use anything else besides vlookup

like

PWC2, xlookup does the exact thing as index(match) they just eliminated needing two formulas. It’s only better because there’s less syntax/typing to get to the same result

So glad I never learned it

funny

I look forward to not having to google how to index match every damn time

like

All people in this thread literally cracking one off to index match at this point. I’ve never had a discussion about... just do it

all the index matchers super butthurt. index match always sucked. yeah it was powerful, but this is the same thing, just faster and easier.

Didn’t expect this would be so polarizing! Fortunately for me, xlookup doesn’t replace index-match-match so I’m not totally useless yet.

Actually, you can do a double xlookup to accomplish an index(match(match))

like

Related Posts

Would anyone like to share anything interesting about a recent project they’ve gotten to work on?

like

If there are any recruiters out there looking for a SE with 5 YOE 3 of them as a SE in the digital identity/authentication space , feel free to reach out to me .

like

Anyone from Citiustech Healthcare Technologies CitiusTech

Is salary credited?
I have icici salary account, but salary hasn't come yet.
When will it come???

Does any one work at Georgia pacific? Honest reviews ?

like

How do you ask for a raise when you know you're not getting paid the average salary wage? I've been reworking for the company for 4.5 years.

like

What is a normal salary for a outbound supervisor?

Heard that some EY colleagues received H1B lottery selection notice in their email just now!

like

5 hours of BRD review sessions today. Need help! Please send memes!

like

Is it weird that I m traveling with my child to see my family while my wife stays back? (Side note: she had a drama with my mom a few months back) is this what I should expect going forward?

funny

Has anyone successfully lightened darker knees? If so how? I want them to be same color as my legs

like

Can any 🐠 who purchased a foreclosed home share your experience? (How did you finance it, were you able to look inside the house or have it inspected, how did the auction work, did you use a realtor or real estate attorney, etc?) TIA for any insights & lessons learned you can share!

like

How much of a raise are you getting for 2023?

like

Got tickets to the World Cup by man flights are expensive and so are mike redemptions. Anyone have tips in find best award availability?

like

Hey everyone, I just needed some real advice, I’m 27, I’m what you would consider a loner, have very few friends (I have aspergers), life seems really bleak rn, I need advice on how to make lonely feelings going away, because I’m starting to have really scary thoughts consistent every day and am losing hope. Any advice would make my week.

like

Has anyone been to Chamonix for skiing?

Wondering where the best area to stay in is and how easy it is to get around?

like

What is the general consensus on online I/O psychology programs? I’m looking to pivot into HC consulting and am strongly considering USC’s online MAPP or Harvard Extension School’s I/O Psychology graduate program.

like

VMLY&R Seattle, I hear hit or miss things about other offices. Wondering what your thoughts are about specifically Seattle?

like

Who stole bacon from kitchen counter? I didn't steal bacon from kitchen counter! :-)))

Post Photo
likefunny

Do we have any RPA BA in this group?

RPA Business Analysts?

like

I'm being deployed on project which has JAVA ANGULAR MONGODB AZURE as Tech stack . Is growth good in this technology for future growth in perspective of opportunities and hikes? What will be available package for 2YOE with this tech stack? Mindtree

Additional Posts in Consulting

Those who made it to Deloitte mid-career (exp hire), how did you do it?

likefunny

What are first year consultants making at Accenture?

like

Does anyone here find the headrest on their office chair super helpful? I've never had one, and can't imagine it's necessary as I shop for a new chair, but want to make sure there isn't something I'm missing.

like

Best consulting firms for strategy in the US besides the big 4 and MBB?

like

Army vet here. Have had a 12 year professional career post Infantry NCO. Now I’m considering pursuing a direct commission to reserve civil affairs. Two questions. Is this crazy/stupid? If not, any ideas on how to make it happen beyond traditional recruiting routes?

like
like

Has anyone heard if United is extending status for Gold to 2022?

like

Where are my fellow straight consultants playing with men while traveling? ;)

like

Accenture peeps what is typical raise % from C to M in strategy?

like

If your entire team went on strike and stopped showing up/doing work to get higher pay, better "conditions", etc. what would happen to you? Get fired? The firm acquiesces and fulfills your demands?

like

It is my first year in consulting. I started as a PMO and at the moment I am a scrum master for an international project. I am very ambitious and would like to grow in the consulting world. Any tips or advices? It will be much appreciated.

like

OTS is growing rapidly and leadership has asked us SMs to assist with recruiting. One of our needs is for cybersecurity and data privacy consultants interested in M&A e.g. CISSP, CISA, CIPP, CIPM, etc

like

Has anyone ever went the Brand name Firm -> Boutique route? Any regrets or insights?

like

I heard Accenture pays more than McKinsey

funnylikehelpful

Went on three dates in last three weeks. Two of them backed out when they came to know that I travel everyweek. The one left was unhappy this morning when I got up at 4 to catch my flight. FML !

like

Saw this on Reddit, Sample size: 4000 consultants

Post Photo
likesmarthelpful

Dixon Hughes Goodman Risk Advisory, anyone know anything? What is the consensus?

like

Tips on pushing back on an over bearing and micro-managing senior manager?

like

going to be alt-traveling to Detroit at least once a month. need living accommodations once my marriott points inevitably run out. is Airbnb my best option?

like

I'm so jaded 😬

Post Photo
likefunnyuplifting

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal