New to excel and need to decide whether to learn vlookup, index/match, or xlookup first. Which is your go-to?

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

=INDEX (column to return a value from, MATCH (lookup value, column to look up against, 0))

Vlookup is kind of limited

like

Xlookup is the best

like

Unless your client isn’t using xlookup then you want to use index/match for backwards compatibility

like

Index Match - not because XLookup is worse (it’s a major improvement), but because:
1) Some clients may require you to do work in their environment, and will only have an older version of Excel (without XLookup)
2) You may be asked to take over someone else’s spreadsheet that uses Index-Match
3) Index-Match is less memory-intensive than VLookup on massive (for Excel) datasets, if for some reason you aren’t able or allowed to use proper SQL/Python/etc tools to analyze it

like

Xlookup is the new Index/Match

like

Index match is incredibly powerful. I would get used to those because there's so much you can do with it.

like

lol oof. Well vlookup takes two seconds to learn but is limited by only searching based on whatever is the first column you have selected. Index Match is much more powerful and not as limited. I recommend learn both. Takes you 20/30 minutes and two youtube videos

I just use index and match because it’s more versatile. Should probably teach myself to do xlookup though

Related Posts

Thursday wordle 467 3/6

🟨⬛️🟨⬛️⬛️
🟨🟨🟩⬛️⬛️
🟩🟩🟩🟩🟩

likesmart

Diamond Peak Holdings Corp is being investigated by WeissLaw for possible breaches of fiduciary duty. Sell?

like

Hi Fishes,

I need 11 likes to unlock DM feature.

Thanks in advance!

like

Is BRK-B a buy right now?

like

What can you say about Armstrong’s New Zealand. Particularly Peugeot dealership?
Has anyone worked there?

like

Looking for a Manager or Sr Manager based in Charlotte or willing to travel there weekly (M-Th) for healthcare tech for large hospital system. Inbox me for details.

like

Hey ladies. I had a miscarriage July 2021 and my cycle started back up not long after. Then in January it just stopped. It’s been 3 months without my period and not sure what could be causing it (I’m not pregnant). My diet hasn’t changed and neither has my activity. I run marathons but I’ve been doing that for years now and it’s never impacted my period prior. I have an appointment to see my OB in a week but wondering if any of you experienced this.

like

It’s Wednesday! How we feeling? Any tea? Heard stealth layoff are happening but not 100% sure if it actually happening.

like

Considering a move, help! I teach k-12 vocal music at a school where I have/had a vision to improve the culture of singing (very sports focused small school) to build a choir program, which will take several years (2 years done). Been working diligently with my elem. music classes to create a climate where students are comfortable/willing to sing. I'm estimating 3 years to see middle school students buy in, and 5-6 years before my high school program sees any fruit of that labor. Stay? Move on?

Favorite go-to brands for summer blouses. Prefer button ups or simple blouses. Brand recs for the sweaty chic chick??

like

What should I ask in total comp- senior manager IT role in consumer goods company? Location - Greater Los Angeles

like

LinkedIn seems to be awash with agencies saying you should pay work experience a wage. Given the short nature of work experience (1 week) the administrative nightmare of payroll we don't. So was wondering does your agency pay for work experience?

like

Extremely off topic but I’ll still go ahead an ask 🥲 :
Are the pushpak buses still functional from Gachibowli circle to airport ? I don’t see them these days in kondapur area so , if anyone from Hyderabad can help with this info 🙏

like

List places who hire fed consultants or share ideas/tips to help others.

like

Hello- I’m interviewing for a change of position at my current employer. It would be my first true sales role, I’ve been in sales support as a product BDM for about 5 years, but never had my own accounts and dedicated quota. Any advice for the interview process? What questions should I ask? Anything you wish you did before accepting a sales job?

like

I'm teaching a 6th grade replacement math group and trying to find ways to help students who struggle with subtraction. What strategies have worked for you? Fingers keep getting counted wrong!

like

Happy pride. New York Road Runners, the group that runs the New York City Marathon, has added Non-Binary as a category for runners. 🏳️‍⚧️👩🏻

Anyone here a member and re-declare?

Post Photo
like

My therapist just said he could no longer help me because I went back on social media to see what my ex has been up to when I said I wouldn’t. I don’t know why this is so wrong. I’m sorry that it’s taking me longer to heal and I’m not ready to let go.

like

Salmon Wellington (Salmon in a Flaky Puff Pastry with Spinach Cream Cheese Filling)

Post Photo
like

Additional Posts in Young Consultants

Did anyone else who got an offer feel sad and guilty about leaving? Wondering if it's because it's the first time I'm quitting or if it'll always be hard

like

Should I be concerned for my career with lack of billable projects? Background: Analyst hired out of undergrad in July 2020. I have worked on 3 proposals in the last 2 weeks, and 5 in the last 2 months. In the past year since I was hired, I have 8 months of billable work which is actually slightly higher than the other Analysts I joined with. Should I keep collecting paychecks and hoping for projects, or is this a serious issue that should prompt an exit strategy?

likefunny

If I may ask. How are y’all networking so far? Every book I’ve read talks about offering help or a win win situation. Do you just stay connected to college friends? Do you take the time to write good linked in posts ? Have seen much success?

like

Interested in finding a way to earn extra income in my free time. Anyone involved in any side hustles that they wouldn’t mind sharing details about?

like

Anyone at NYC AlixPartners or Alvarez & Marsal willing to chat about their role in RX Consulting?

like

Hey guys,
I’m working at Management Solutions in my Rome since I have the desire to work abroad I sent my CV around the Europe.
Deloitte called me from Barcelona to schedule an interview with the HR.
The position is in the accounting sector of Deloitte DBS. They told me that the base salary (I’m an entry level) is 18k per year. In Rome I’m actually earning 28k+1k bonus.
Anyone knows why there’s such a great gap in salary? Tomorrow I’ll have the interview so any comments could be helpful. Thx

like

Trying to transition out of Accenture into KPMG after 2 years of experience. Probably at the Senior Consultant level for salesforce. However, I’ve never switched companies before but I want to be sure I’m compensated correctly. For that level and practice - how much should I be asking/expecting?? I don’t want to undersell myself and have the confidence to ask for what I deserve

like

hey guys! I have just been selected for a trainee position at EY in the Data&Analytics consulting area, I don't really know what to expect from the tasks and requirements. And yet my degree is in accounting, although I know the basics of It. Does anyone know a little about the area?

like

hey 🐠 looking for some likes so i can dm some people. thanks!

likeuplifting

Just hit the 1 year mark a couple months ago and I'm at my limit. I haven't been able to focus at work to the point that I'm getting nothing done despite taking time off. Who here has been in this situation before? I'm thinking of making more drastic changes like rolling off of my project if I decide that this isn't sustainable.

likehelpful

Who wants to play League of Legends with me? Hmu

like

Has anyone heard from McK or Bain for summer 2023 internship NA? I heard some people heard about McK NY but no it her offices?

like

Suggestions for volunteering in NYC? Want to be productive with my free time and get involved in something engaging and meaningful. Looking for 1-2 hours per week.

like

I got a full time offer from the company I interned at this summer. However, I have been applying and interviewing at various consulting firms so far. Some of them I won’t hear back until September/October. Is it wrong to accept the offer and then reject it if I get a better offer? I don’t wanna burn a bridge with this company since I really enjoyed my experience there but I have to be smart with my decision since I graduate in December and need an earlier work start date.

like

Anyone ever give themselves a gift for a promotion? I was just promoted and thought about getting something I wouldn’t otherwise get to celebrate. 24M for reference, I almost never spend money on anything besides rent, food, and going out on weekends.

like

Hi everyone, I am currently working as a senior analyst in a Group Purchasing Organisation (GPO). Looking to switch to consulting, it would be great if anyone can provide referral for any of the following firm’s Boston Consulting Group, Bain & company , Mckinsey, KPMG, PWC, EY, EY-Parthenon, Strategy&, L.E.K, Kearney, Deloitte, Oliver Wyman, Booz Allen Hamilton

like

Any advice for somebody at the start of their career (2021 graduate) looking to move away from M&A Integrations work into roles where the work is based around "problem -> hypothesis -> analysis -> conclusion" rather than just putting together the puzzle pieces of a deal in the later stages? Would really appreciate advice on what my options might be in or out of consulting, just not loving how things have been going recently.

like

Recently graduated from university with an engineering degree in 2021 and started working as a field engineer but realized I want to try business management consulting. Any advice for a young experienced hire looking to transition?

like

I studied econ not graphic design!!!!!!

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

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