{ "media_type": "text", "post_content": "18 years of education including a Masters and nobody ever taught me the most important skill ever: vlookup\n\nNo wonder the current education system is so off!", "post_id": "5bd332156a211a0017363c5f", "reply_count": 22, "vote_count": 60, "bowl_id": "552d1d24dc1c586b09d2d051", "bowl_name": "Consulting", "feed_type": "crowd" }

18 years of education including a Masters and nobody ever taught me the most important skill ever: vlookup

No wonder the current education system is so off!

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

Index match

Looks like they still didn’t teach you at Deloitte 😬


It took <1 minute for the index match fans to jump on this!


Director told me not to use index match because he doesn’t know how to use it. Then asked me to explain sumproduct


Now it’s time to tackle index match!!!


Add in indirect tab referencing to loop through tabs 😍. I'm a little too excited


Index match is not only more powerful, but also more performant


We've got a new Excel user, here. Don't answer the door when the Tableau evangelists come knocking.


^Index Match is life-changing 🤗


Tell Roland Berger Sr. to watch YouTube and up his game


You can master VLookup in about 10 seconds... don’t sweat it... you should learn Index Match though... I agree with the hype!


^A1 what on earth does that do?


Try index match match?


Same... there was a class for it as an elective but I chose DB classes instead

Index match baby. Vlookup aint nothin

Index match

Big D leading the charge as always

Why are you still using Excel? That so dépassé...

=Sumproduct(oo10:xx100*—(yy10:yy100=a)*—(zz10:zz100=b)*—(oo9:xx9=c)) this will change your life!

Offset better than index match...

BA1 index match on steroids!

Additional Posts

Might be a common phenomenon, but I have put on some considerable weight and because we never had to go out, didn’t bother shopping for a long time. Now I have to go back to the office and none of my clothes fit me. Where can I buy good quality plus size formal clothes?


I am looking for a sleek case that can hold my different cords and external battery pack. I had a bubm case but the one I got was too bulky. What do you use to keep all your gadget cords organized?


I interviewed for a tech product position at Amazon but was offered non-tech product, with promise of transitioning over to tech within a year. Has this happened to anyone? How has this impacted comp?


Uniqlo stretch wool custom jacket. Is it good ?

Deloitte to competitors right now! 😛

Post Photo

What does one do when a female client stakeholder undermines every sincere input one provides? Getting mansplained and undermined by a woman, when I am trying to help her- weird vibe...


What is this guy talking about???

Post Photo

What are good interview questions to ask to partners/MDs after the end of an interview?

Any corporate associates who like what they do?


If you work for your Dad how are you paid? Approx how much do you make ?


I am vaccinated, my fiancee is not. His reasons seem logical (ie he's not a crazy conspiracy guy). My sister has her big Indian wedding in the US coming up in December (150+ people), and has requested everyone be vaccinated. Should I ask her to make an exception for my fiancee with certain precautions in place (ie, testing each day, mask, minimize crowd interaction like dance floors)?


Hi BCG 🐠! I’m looking to apply for the Project Leader position, focusing on Post-merger Integration. I’ve done M&A IT work at both D and S&. Would love to chat more for insights.

What's the average rate for a professional illustrator *Bay Area Tech giant* if I'm looking to comission a series of posters? I want to reach out to a few folks, but I've never comissioned this type of work before. Any tips?


Dear Fishbowl PPCers I need your help!

A client is insisting we used Adobe bod manager for their campaigns, and neither me nor my team have experience with it.

We're also not on a timeline where we can really get up to speed on it ahead of a couple deadlines.

I've also argued for budget for external consulting hours and that's been disapproved.

I'm on my own. Or am I?

Hoping some kind soul with experience managing Google Ads through Adobe can help me out.



Depression is making me tired all the time. It’s impacting my ability to focus and be productive at work. Any advice on how to get through this?


How do you get work done if you have a tight deadline and also need to make sure the quality is there (as a staff)? Especially when there is no clear instruction was given.


If I'm on track to get a bump from Senior to ACD (promoted internally, not going to a new spot) how much of a pay bump can I reasonably expect, if I'm starting at 85K?


New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
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


Embed this post

Copy and paste embed code on your site


Download the Fishbowl app

For account settings, visit Fishbowl on Desktop Browser or