Xlookup >>>>>>> index match.

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

I mentioned VLookup in a training class last week and knew I’d get skewered.

But yes, XLookup was the consensus! Whatever the heck it is…

like

Index match for dummies. Aka me

like

/s

Post Photo
likefunny

I agree

like

But…isn’t it….slower?

like

There’s a middle spot where the data is large enough to become annoyingly slow, but not large enough to warrant me googling how to power query. One tab with lots of data is fine. Two tabs is fine. Three is fine. But stuff adds up reeeaaal quick sometimes…

I know PMs that I have shown xlookup and index/match, explained the differences, and they still go back to using vlookup.

For one of them, it was the final straw that got me to roll them off my project.

funny

Jfc hahahahahaha

I am oscillating between laughing and crying cause that is my life the last 6 months and get to do more tomorrow.

like

PowerPivot FTW!

Related Posts

Why some companies ask for Scrum master with technical skills when Scrum Master role is non technical. Please share your views

like

JIRA for Agile Projects

Post Photo

Hi can anyone please share me the work environment in Mphasis Hyderabad as Senior Software Engineer ??

Does Bain and BCG have an implementation arm similar to McKinsey Implementation?

like

What does an internal facing Strategy director at KPMG do? Kinda sounds nice-ish. Anyone with experience ? Recruiter says great pay and good WLB but any primers?

like

What is expected ctc in zs associate pune for 4 years experienced java Full Stack developer?

Anybody interviewed for a data engineer role for Facebook? I have a SQL and Python coding interview next, any idea on what to expect?

like

Have an offer from Kroll and FTI. Which one you guys think is better?
Same position and same pay range.

Looking to do an internal transfer at UBS. I saw they are hiring Credit Officers in Nashville. Could someone please share the salary range for an associate diretor and a diretor role? Thank you

like

Any Capgemini H1B US employees here…
What is the standard procedure to resign? The recommended notice period is 2 weeks but any indirect penalty if you don’t do so?
Capgemini

like

Me at recruiting events

Post Photo
likefunny

Single BigLaw-yers, how often do you have sex? How the hell do you even have the time to meet new people?

like

How is the future in SCM WMS (Manhattan wmos / Jda wms) ?? I am a btech fresher and got this , is it good to start a career with it ??


Cognizant Tata Consultancy Infosys EY Accenture IBM Wipro

like

Can we get a thread going of Senior Product Designer salaries.

I am currently a contractor and make $65/hr.

like

What is a typical starting rate that young attorneys charge for per diem side work? First or second year lawyers should ask for what? Client is a big firm.

like

What are the Designation level at HSBC GSC for Hyderabad location. What is the band for Assistant Manager

Hi, I work for a non-profit and we hire nationwide for 2 positions as well as locally for numerous positions. I’m looking for recommendations, reviews and any advice for online job boards. We use Indeed, Glassdoor, Craigslist, just got back into Zip Recruiter and working on getting LinkedIn up and running. Any help is appreciated.

like

Hi community, humbly seeking professional HR advice. I recently joined my company’s HR team. In an informal conversation, a senior HRBP, considered a peer, called 2 of our fellow HR colleagues “worthless.” I should have rebuked her then & there but was so caught off guard. This person is 20 years my senior. In the same conversation this person advocated for me on a separate matter & complimented my performance. I am not sure what course of action to take at this time. Distraught & unsure.

like

Happy Sunday ✌️

Post Photo
likeuplifting

Just had an interview with praseed nair, manger infosec, he seemed so confused on whether to hire from a big4 or not, what does other's have to say?

Additional Posts in Consulting

I’m in industry and have gotten feedback that I should be “more strategic” in my work. Can anyone translate what that means please? My team is from consulting

like

How do I become an MBB employee? Is it possible to gain experience at big 4+ACN and then get referred in??

like

Any good book recommendations? Both fiction and non

like

Hey FB fam. I’m putting together Financial success resources. If you have any books, articles or podcasts in relation to personal investments or real estate you recommend, please feel free to share 🙃

like

2yrs of post-undergrad experience at D and have offers from two FAANG companies. Worth it to stick it out for a couple more years to open up more offers down the road, or should I get out while I can?

like

Hate this project, this client, and this team. Have to stick it out another 5 months at least before reapplying to other firms. Lord give me the strength...

Favorite coping mechanisms appreciated. It's going to be a long summer.

like

Booz Allen to KPMG or Grant Thornton if you had to pick? We seem to be falling hard into dysfunction. I am currently a Senior Associate.

like

Somebody say layoffs?

Post Photo
likefunnyhelpful

Does anybody have good electric standing desk recommendations? Ideally in the $200-300 range.

like

Hey fishies, I have a friend who is interested in becoming a consultant but he’s taken an interesting path, would love your advice on any good angles he could take for applying/ types of roles. He has a bachelors in science (chemistry maybe?) from H/Y/P and after undergrad he took a less traditional route and was working as an instructor for things like tennis, piano, snowboarding, etc.. He’s a really smart, personable person who I think would be great in consulting. (Continued)

like

Accenture folks:
1. Does Accenture do tuition reimbursement?
2. What level number is a consultant?

likehelpful

If you sign an offer with another company, when should you tell your current company?

like

Group of analysts went to the most expensive steakhouse in the city, on the way out run into our partner, SM and the client who says "well you guys had a nice expensive meal..." Tomorrow should be fun

like

What are some of the best consulting firms for a software engineer? Is MBB still considered elite in this area too?

like
like

How did a project failure (that had consequences for the client) affect you? How did you feel, and how were you able to move on? I feel like I'm watching all of my hard work go right down the drain...

like

Have the Big 4 raised their initial post-MBA salaries to somewhat match the recent MBB offer changes?

like

Hi fishies. I have a ton of interviews coming up soon including a case interview at EY within their Innovation and Experience Design practice for Digital Strategy Manager. I am super comfortable with CX, design thinking, etc which are the types of projects I would be working on BUT I am absolutely terrible in case interviews. I was hoping it would be based on CX or design but my understanding is there is some revenue component idk. Anyone have any insight? I would greatly greatly appreciate it!

like

Is genetic testing for diseases covered by most health insurance? Has anyone ever done this, do you recommend it.

like

What’s the worst US city and why is it NYC?

likefunny

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

Scan your QR code to download
Fishbowl app on your mobile

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