{ "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" }
null

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!

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

Index match

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

likefunnysmarthelpful

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

likefunny

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

likefunny

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

likeuplifting

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

likefunny

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

like

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

like

^Index Match is life-changing 🤗

like

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

likefunny

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

like

^A1 what on earth does that do?

like

Try index match match?

like

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?

like

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?

like

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?

likesmart

Uniqlo stretch wool custom jacket. Is it good ?

Deloitte to competitors right now! 😛

Post Photo
likefunnyuplifting

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...

like

What is this guy talking about???

Post Photo
like

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

Any corporate associates who like what they do?

funnylike
likehelpful

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

like

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)?

funny

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?

like

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.

Continued...

like

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?

like

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.

like

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?

like

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

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the Fishbowl app

For account settings, visit Fishbowl on Desktop Browser or

General

Legal