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

What are y’all’s thoughts/experiences with Fundrise? Don’t have much cash to buy real estate, but the returns they boast seem on par with less work. It’s not liquid so thinking abt 5 yrs for down pmt?

This bowl has helped me so much in the past year and I got set up with my brokerage account. I feel ready to get started in the crypto space. Where do I begin?!

like

Would you wait for the market to cool down (if it does at all) instead of rush to buy a single-family home esp in north Dallas areas like Prosper, Celina?
Currently, observing homes at ~$250/sq ft in these areas?

like

Hey Everyone! I have a 7 year background as a Project Coordinator and currently in a Digital Marketing Consulting Role. I am would like to get back involved in Project Management (Scrum Master) is anyone or know of anyone who is hiring for a Remote position? I am not currently Certified but very interested in taking the courses to become certified. TIA :)

like

Slalom 🐠, can someone provide insight on how the in person interview is for a Data Analytics consultant?

like

Anyone have a rec for a recruiter that can help with L&E in-house opportunities? Been trying to apply for openings on my own but not getting much traction.

like

Anyone use ice cubes for calming down acne? Will it age your skin quickly ? It makes my acne so much less painful. But am worried my skin will age soon

like

Really enjoying these Book of Mandalorian episodes

like

I'm Becky and I teach in a play-based public school preschool in Minnesota. This is my 24th year, all in 0-5 and parent ed!

I’m convinced those graduate certificates from top business schools are solely to collect LinkedIn badges. No Karen you did not actually go to HBS or Wharton please stop pretending it’s your alma mater you’re not fooling anyone.

likefunnysmart

Is it weird that I don't want a family ? My parents relationship wasn't the greatest and I was in a 6-year relationship that went no where. I just want to be by myself and I wouldn't want to put effort into having children with someone.

likesmart

Hi. A bit new to audit and have a question on a report's opinion.
I came across a somewhat old auditor report (from a very small auditing firm) that listed several instances where employees misappropriated assets within its schedule of findings, yet the opinion was unmodified. Is this fine? I would think it'd affect the opinion not knowing everything that was misappropriated. Could it be that the auditor felt comfortable enough on how much they identified and that lowered the risk?

like

Is EY GDS is in GUJRAT LOCATION??

like

Anyone has Mphasis HR mail id?

like

What is one piece of advice you would give someone considering a career in marketing?

like

We just had our first week of at-home school. Not sure if we will need extra help. Does anyone have any tips/advice/things that work for them?

like

What salary should I expect for an entry level tax consulting/advisory position in Dallas, TX?

like

Any recommendations on growth stocks to buy now ? I missed the Tesla run....

like

Are folks liquidating their pensions?

like

Do y'all think we should have a law in place that requires you to live here fore at least two years before being able to buy a house? So many transplants, I feel like my city is changing before my eyes.

likefunny

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

Has anyone experienced a superior demanding a task’s completion ASAP only for it to not be due until much later? It gets damn draining at times when people over stress on non urgent tasks making it seem like it’s due ASAP, having to shift gears, only to realize there wasn’t much stress to be had to begin with

like

Do you all go through GL detail to look for potential adjustments?

like

Anyone know the salary for a S1 SALT M&A in A&M in Chicago?

like

What is SM1 salary at PwC?

like

I'm an assurance staff 2 looking to switch to FDD in CA Bay area. Appreciate if anyone can provide referrals for FDD associate position in CA Bay area. Thank you.

like

Just took a look at the Riveron. So white and so male dominated. But what do you expect. It is a TX based firm.

like

Any partners willing to share what their comp is,what it looked like when they first made partner and what size firm they're with?

like

For those at PwC in Delivering Deal Value (and others at different B4 doing similar work), what does your average day / work look like? Thinking of lateraling from audit when the economic recovers, but don’t know what really to expect.

like

Looking to make switch to IB. How should I describe my FDD experience in my resume?

likefunny

Anyone know anything about Embark’s transaction advisory group?

like

FDD Senior & FDD Manager salaries in Denver? I'm guessing they're 20k lower at each level than in NY, so around ~90 for senior, 110 for manager?

like

Other than Tax Due Diligence, how can someone only has tax experience transition to transaction or deals related work?

like

Does A&M have an accounting advisory service line?

like

What is the S3/M1 FDD base salary for EY? (MCOL) Appreciate the insight

like

Has anyone transferred to FDD in late manger years (M2/M3) from audit or accounting advisory? Has the transition been hard? Any advise would be appreciated!

like

Has anyone have an experience they want to share in using a paid resume service to boost an opportunity they were able to get?

Given how crazy deal flow has been recently, do you do think interns will work more than the standard 40 hour week this summer?

like

Kroll is still growing, busy, and hiring in FDD. We’re looking for people with 1-2 years of audit experience and CPA or prior TAS experience. Please let me know if interested.

like

PwC go with the title “Finance Due Diligence Senior”, What’s the title for Deloitte?

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