Is index match still used or has it been replaced by x-lookup? New analyst here having to learn index match (which is fine) but I always thought xlookup is superior.

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

If one of my analysts or associates used a x or vlookup, I’d literally restaff the project.

funnylike

Everyone uses index match

like

I think of XLOOKUP as a better VLOOKUP and index and match as superior to both

like

Hmmm okay I’ll do more research, thanks!

like

Index match is the best out of the 3, and quite straightforwarx once you get the hang of it. Highly recommend

like

Index match logic makes more sense to me than vlookup

Index match is superior! Learn it and it will be more useful on those late nights!

helpful

Also I think it’s harder to audit xlookup or hlookups too.

helpful

Im a big fan of x lookups but stick to index match in live models because i dont wanna get yelled at lol, plus also concerned that there could be a backwards compatibility issue for older excels without x lookup

like

What can index match do that xlookup can’t?

Not that it can’t do things index match can’t, it’s more convenient and conventional to just stick to what works/was reliable with huge convoluted databases.

Hello

Related Posts

Im a campus hire with limited experience and engineering major. I have a basic cert in sap but im looking to learn more about new technologies/skills so im more likely to get opportunities and grow. What would you recommend?

like

Can recruiters ghost you after agreement on salary and HR discussion?

like

Has anyone defined themselves by their passion for this industry so much so, that if they thought about doing something else they’d have no idea who they are anymore?

Does that even make sense?

like

Anybody here who are happy to help aws beginner... I m having 6 years exp in other tech... Bt need to work on aws app synch and lmbda resolver... Anyone who can help on that.. I need a basic aws app synch api which with lmbda resolver and lmbda as datasource ... Just very basic setup I m doing getting authentication error... Anybody who has knowledge please help me... May be I can help u in future.. Thanks

like

The house has fallen. I feel in my bones. I feel my bones. The eyes of the others and the silence on the calls. The shareholders demand growth. Growth continues. Continues. Continues. The host is gone. The AI is born. It was the eighth of December in the year after the pandemic. The stocks have reached the end of the hyperbola. The shareholders demand more. Long live death. This was written by a human. Fifteen days. Fifteen days. Fifteen days

likesmart

Clopening is sooo draining, I can’t believe it’s legal to make people do that. Seriously, can we not make laws about this stuff?

likeuplifting

I work in health strategy Consulting. I am loooinng to exit Into sales. Any advice how to best go about the process?
What positions / companies are recommended?
Any trainings /certs that would look good?
And anything I might be missing?

like

What has been the experience of people using Sarwa?

likehelpful

Any cyclists in the group?

Ping me if you want to join me on the trails! (Katy/ White Rock/ Santa Fe)

like

How have you used plickers in the classroom? Is this a daily part of anyone’s lesson?

Post Photo
like
like
like

Hi fishes, which company is better Deloitte India vs NatWest Group for Data Engineering role? Deloitte India Natwest group

like

What is the notice period in ihs markit?

like

Sherin John from Blockgemini looking for a Project Manager, please get in touch with him if any one is interested.
Location Bangalore
+919940354709

like

What is the culture of Salesforce practice within KPMG? How is it similar or different to rest of the company? Curious...

like

Any national security lawyers on here? What are the billables and what are you generally doing? Is it essentially gov’t relations and researching/drafting opinion letters or is there more to it?

like

Need advice pls . Been working in call center customer service for the past 15 years , since 2007. I work remotely .I really do love it . It’s convenient when you have young children. I just feel stuck , don’t have much education besides my high school diploma. How can I further my career and make more money in this field but not be stuck answering phone calls . All suggestions are very much appreciated

like

Hi, is there any tentative dates as to when we’re expected to join office?

I just received my offer and my joining date is end of March

like

Additional Posts in Investment Banking - IBD

How do you guys describe what you do when you don't want to tell people you're in IB without lying?
I'm really sick of people assuming I'm rich if I say I'm in IB, but don't want to completely lie either.

like

Does IB coverage or M&A team pay more at a BB?

like

What are people’s thoughts on cold emailing MDs or Group Heads of a group that is hiring/that you are really qualified for? I don’t know anyone at a few firms where I think I would be a really good fit that are hiring, is it worth a shot?

I have got offers from Goldman Sachs and Morgan Stanley as Project Manager VP. MS is on Enterprise Technology pm role and GS is on the Wealth Management pm role. Both have the same TC.
Which might be the better choice and why?

Morgan Stanley Goldman Sachs

like

What are some TMT-specific interview questions interviewers like to ask?

like

How easy is it to move offices? Thinking about moving from NY to London

like

Any take on culture of MS Menlo?

like

What should all in comp be for first year associates? Base I got quoted is 175, trying to figure out what % of base to expect with bonus. Should I get min bonus language in writing with the recruiter in the offer letter?

like

Does anyone have a Wall Street prep guide for restructuring?

like

Hey all, anybody knows TC for an Analyst or Senior Analyst at EY Canada in their M&A Capital Markets Advisory?
For context: I’m looking to break into IB and made a connection who referred me to a manager there. Said there’s a great fit and wanted to have a coffee chat.

like

I am a new jr. credit analyst at a commercial banking institution. I've been there 2.5 months so far, and feel like I'm doing very well, as does my boss. I do not have a finance degree, but a business admin degree instead. I didn't plan on banking, but I left my prior industry and got this job through someone I know knowing someone at the bank. I'm 24 years old and my business degree is from a very solid business school. What should I be getting paid (salaried)? Curious if I'm being underpaid.

like

I had several interviews with Deutsche bank and they have verbally offered the job about 2 months ago. I noticed on Workday Tuesday the status says "offer in progress". In the time between, I did get some calls the offer is still in progress and is slowed down due to manager out of office (among other things). How long should I wait until I need to call back and get an update? And this type of situation commonplace?

like

Hello everyone!
I have a HireVue interview from Goldman Sachs. I wanted to know what type and how many questions would be asked in it. Thank you in advance!

like

What are the non vanilla adjustments you make to go from EV to Equity Value and how do you identify them in a public company’s 10k? Pension obligations and debt like items? Do operating leases get subtracted out

Thoughts on joining HBO Max in the midst of the WarnerMedia / Discovery merger?

likehelpful

Any advice for moving from being a lawyer to secondary advisory or private fund groups that combine this with placement/fundraising?

like

Of the boutique / middle market banks, what coverage groups are the strongest / have the best reputation? Looking at the likes of Evercore, Moelis, William Blair, Piper, PJT, Lioncoln, Harris Williams…

like

Folks, can we please share some good resources to study for Saas revenue models please? Thank you!

like

How’s WLB and comp in EVR’s PCA group?

like

Do most BB LevFin teams own the modeling? Heard some don’t and deals is primarily run through sector team

like

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