Is indexmatch superior to xlookup? I know it is superior to vlookup/hlookup.

I am wondering if xlookup can do all that indexmatch can.

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

a lot of people don’t use office 365, so if you send over a sheet they will get a bunch of errors. Index match is still the universal standard

X lookup is better though

like

I use xlookup because we don't include that when sent to the external party.

like

Is there a certain requirement with xlookup like all values have to be in number format? I keep getting errors when using the formula but cant figure out what I’m doing wrong. It’s a pretty straight forward function

I’m not sure cause I’ve never tried that route so maybe

Related Posts

June gloom. That is all.

like

Anyone have restaurant recommendations for a work dinner that can accommodate around 15 people without having to book an event room/space?

like

Anyone have any insight into the most recent base salary for S1 PwC advisory (Management consulting FS)?

like

Is there any openings in supply chain management in metro?

BLUF: Relocation doesn’t include breaking my current lease. Am I in the right to get that covered? Story below:

Dating and relationships have always been a struggle for me. Either the woman ghosts me after the first date or just a personality clash. Been married for five years and thing we’re going well but over the past two years everything is my fault and I do nothing right and get verbally abused so much at this point I do not know what side is up anymore. I know what needs to happen I’m just scared

like

I had a failed natural FET in Sep & did a mock transfer 2 weeks ago (HFET). Results came back Receptive. I got my period 2 days after stopping the PIO. RE mentioned I can start embryo transfer this week & did not need to wait for my next cycle. My periods are not always regular, so I like the idea of not waiting for them to start but also nervous if this could impact the embryo transfer as it would not follow the same timeline as that of the mock cycle. Anyone try this approach with success?

like

When a company says to choose between resignation and termination, what to do?

like
like

U can’t be wrong if you’re investing in index for long term

Post Photo
like

Having such a hard time find a spot in Chicago

likefunny

I have $30 remaining in my technology subsidy. Can I use it to pay part of a purchase of an earphone set worth $200

Any RBP companies in Philly or remote hiring?

like

Anyone have any Boston area firms they would recommend working at? Considering a change

like

Anyone at UHG? Someone within HR? Need to pick a brain on a few things..levels, merits, etc

like

What will happen if leave Musigma before my bond period? Will I have to pay bond amount or

they will just not provide experience letter(if I don't pay bond amount)? Mu Sigma Inc.

like

What's a rule you are expected to enforce that you strongly disagree with or are indifferent to. Do you enforce it or take the risk? I move around as a tutor and am currently working with a school that has a ridiculously strict formal address policy. One of my second graders refers to me as "Miss Tutoring (my first name)" - it's about the cutest thing ever and doesn't bother me one bit. We are moderated sometimes and I'm more worried about her getting in trouble than me for not abiding.

like

Would anyone who works at The Hartford be willing to provide a referral? I can PM the job description that I’m interested in. Thanks!

Additional Posts in Transaction Services, M&A, Deal Advisory

Hey folks,
Just curious to know if A&M has an official bowl here. It doesn't appear on my search. I'd be nice if y'all could drop a link in case, thanks 🥂

like

What is exactly shadowing a deal? I heard newbies do that for few months.

like

Looking into Accounting Advisory Roles as it maybe more fit to my background than FDD. Is AAS still a smart career path? What are everyone’s overall thoughts on AAS? Looking for any and all and all info I can!

like

If my base salary is 85k, how much should I expect to hit my bank account after tax? I am in a new role didn’t receive my paycheck yet. TIA

like

Been in FDD for a year, want to move into IB (eventually, at least want to wait a few more months), but I’m not someone who has modeling skills. Best tips to improve? (Besides YouTube vids and what not).

like

Would you take a step back in title to be an analyst at a PE firm (analyst to them is minimum 3 years experience) and a short term pay cut (probably for just a year) if you were in a middle office type role at an asset management firm with ~ 6 years of experience

like

Currently in B4 Tech Risk (senior 1 going to be senior 2) i want to transfer to FDD, preferably internally but looking at other big 4 too. I'm currently set to talk to a manager internally and network but is there anything else that would be recommended for me to do?

Coming from tech risk, what are my chances of getting an offer at any of the big 4s in Fdd? (Im an accting major + MAcc and working on my cpa)

like

Hey everyone. I’ve got an interview coming up for Lead advisory (M&A). I really want the job. They’ve given me a case study with a company (no data just a website) and asked me to prepare a two page report on the company for a partner who is going to help a PE firm that owns the company with the sell side mandate. They’ve said to include industry, strategy, operations, financials and other relevant info. Any tips on what I should include in each heading and how I can stand out?

like

Is it possible to transition from partnership tax to FDD

like

Anyone have any insight on the type of Financial Services companies in Chicago? A lot of Fintech ?

like

Do FDD, Valuation and transaction analytics involve tax aspects at all? Trying to figure out how I can sell my background in PE/VC/Real estate tax.

like

Hi! I’m in FDD and looking to move out of California to either TX (Dallas) or Florida (open to different cities) within this year (around Aug/Sep).
Can anyone speak to the opportunities/career growth available in these cities? I’m not sure Miami is where I see myself in FL, maybe more Tampa—but I don’t think FDD is there.
I’ve heard a lot of good things about Dallas too so trying to keep my options open.
Is Dallas > Florida?

Any insight would be appreciated—thanks!

like

Would you do a 3 month audit busy season if they offered you a 15k pre-tax bonus.

Hi, what is a standard compensation package for Corporate & Investment Banking Associate Coverage Group/ Relationship Management in New York City? Also, do you recommend such group in IB, is it a good move from consulting?
Thank you

like

The PwC Deal leader. Do you have something sad or upsetting? Why do you always wear a frown? A smile really makes the world better.

funnylike

Should I stick with Big 4 audit( currently senior 2 and received good reviews ) or look for FDD sr jobs in tier 2 firms ( Like RSM )

likehelpful

How come we haven’t unionized our jobs? I don’t think 100% of it can be outsourced to India, Mauritius, etc. and given the number of hours we’re required to put in, I don’t believe we have very good working conditions. Just curious in thoughts.

like

Anyone in restructuring that I can DM some questions?

like

Anyone here work at Cohn Reznick? How do you like the team, hours, clients, etc?

likefunny

**Associates** looking to get into the deals, KPMG practice, reach out for referral

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

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