VLookUp or Index-Match?

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

Index-Match

like

Is that even a question?!

like

Neither. I avoid excel.

like

I haven't used index match but it seems more complicated than I want to learn about until I need to use it. Seems like more keystrokes for the same output (in the case of a flat file)

like

Nerdiest posts ever all of you go watch some sports or something please

like

Index match is way more powerful, but people get intimidated when trying to figure out how it works. Well worth the time investment.

like

This logic of "index match ALWAYS -- oh so powerful" is ridiculous. Use whatever tool that is best suited to the job. VLookup for very simple/quick lookups, index-match for more complicated ones, VBscript or other coding for super complex ones.

like

Index-match-match, as an array function, of course

like

SQL, python, R

like

D2 - alteryx

like

Ey1-- hopefully you don't ever have to hand these off to clients because that is a recipe for disaster.. duplicate data, working tabs, etc. Better if it's all integrated into one place from one source of data so that updates can be dynamic. And for the record, if you are already copying and pasting into other tabs and re-arranging, that is significantly more effort than using index match

like

This is one of those things that if I was managing you, I would look at your excel and make you re-do it, even if the "answer" is correct. Good to learn it the right way to save yourself time in the future, then to reinforce at bad habit that introduces a lot of risk into your excel model..

like

VLookUp

like

Index match for sure. Far more dynamic.

like

Posed question after seeing people still talking about VLookUp. I've had a PL who used it too... so frustrating

like

Index match - more powerful

like

Ey1 surprised you've never needed index match unless you actually go and move your columns around and transpose tables to make it work.. vlookup is only usable with very simple data..

like

@M1 if I have to I'll copy the table to a working tab and move the columns around. Haven't yet transposed a table to get vlookup to work, i would probably just use index march in that scenario

like

After learning index match, I never touched vlookup again

like

Do you even array

like

Related Posts

Can someone from data analytics background explain what differentiates palantir from cloud native services from aws, gcp, azure or databricks? I am interested in why one should invest in this company and hence, asking in this bowl.

like

I have an offer from Accenture (Tech: Salesforce, Level 9) and it has 27% variable component.
How much variable pay can I expect? How much variable they pay on an average?Accenture Accenture India

like

I have been offered the role of Assurance Associate. Can anyone please suggest me what salary range I should negotiate?

like

Any good detox diets that good to try out and not horrroble for your body? I want to curb some sugar cravings and bad eating habits over the past year. Has anyone done one they liked? I was thinking of starting a 3 day detox then go into 7days of a white meat/fruit cleanse for a week. Then just stop eating like a complete child on holiday after those are done 😅 any advice on what helped you get past the cravings and level set would be helpful! I heard good things about keto but like options.

like

Say you're hiring for a Communications Specialist. What questions would you ask candidates in an interview?

like

For those who had weddings in a city -
Did you pay for your guest’s parking?

like

How different is Data Modeling wrt to Dimensional Modelling on Snowflake?

like

Describe your body shape and how you feel about it?

I hope you're forever reaching towards the perfect love for who you are 💕

like

Really struggling here. I can work from anywhere for the next month so I took a flight to Italy and have been here for 10 days. Thinking of where to go next - would like to do somewhere in europe or Middle East (Jordan / Israel) but not sure where!! What’re peoples favorite places to go in the winter in this part of the world?

likehelpful

Urgent advice needed! Need to choose between two offers
Nokia or JPMC? Location Bangalore and Same pay offered from both work experience 8yrs

Any good strategy consulting firms in LA that don’t have a toxic work culture? Very ready to leave Deloitte and don’t want to work 60+ hr weeks anymore. Pipe dream? (Also taking recs for other jobs)

like

Do people use their HSA to actually pay for health expenses or just as a triple tax advantaged savings account for retirement? Seems like all talk on here emphasizes the tax benefits of it, so I am curious if people use to spend or just save

likehelpful

Hello all-

I’m asked to work a Throughput report that seems to be off with forecasting. From my understanding we are off by 2,200 being able to ship. I work in Exports for international. Our main system to pull reporting is SAP. Any suggestions what transaction would provide closer accuracy?

like

Where in the city would be good?

like

Any Review on Accenture Kolkata?
Technology Domain: Java Fullstack with MEAN Stack, Cloud, Microservices

I want to know about scope of work, projects, credentials

Opinion on M7 chances? 760 GMAT, 4.0 GPA from a top-tier engineering (Berkeley/GaTech/UMich), 3yrs tech consulting (Deloitte/PwC), Indian male. Assume standard recs, essays, extra-curriculars. Thanks!

Can't believe I'm saying this but I'm thinking about a boomerang back into public accounting. Spent a year in industry and I miss audit, the variety, the hussle of busy season. Left public after 7 years.

Tell me I'm crazy? Current job isn't as many hours, but we're basically "busy" all year rather than a concentrated season or two.

like

Mujhse kch bhi pooch lo mujhe sb aataa h melody khaayi h abhi abhi.

funnylike

Additional Posts in Consulting

Should I be expected to get birthday presents for my fiancée's siblings?

like

Anyone else trying to finally kick that nagging cough/cold before the break? Would hate to have any option short of “all the booze” while I’m on vacation.

likefunny

Looking for Seattle opportunities.. Have almost 3 years of Oracle functional experience.. trying to do something with cloud.. Taking AWS SAA in 2 weeks. Any recommended openings or referrals?

like

For EY-Parthenon, how much does your home office location matter? (the office you're linked with)

Any suggestions on locations? Thanks

like

Does anyone know what industries / competencies got hit by the layoffs yesterday? A few people mentioned it, but no one gave any details.

like

Book recommendations for new executives?

like

what’s the ratio of equity/stocks to bond/fixed income in your Merrill lynch 401k plan?Do you make any modifications or just use recommended distribution? First job with 401k and not sure what to do!

like

Did the wsj pwc layoff article ever happen

like

What is so great about working in Salesforce? What are the benefits everyone raves about and what do they even do? Is it implementation?

like

Does failing a client drug test -> getting fired from firm?

like

What are your top book recommendations? I’m genre neutral.

like

What are good options traveling from the airport to the hotel in London? I'm getting car rates between $110 - $200 for just one way.

like

I worked on a project with Leap by McKinsey and enjoyed it. It's basically planning and launching digital projects from 0 to 1(strategy to MVP).
What are the best consulting companies doing this type of work?

like

Have a potential interview with D in another city. However the date they picked I had a personal weekend trip planned. Fair to fly from home city to interview then rent a car from interview to weekend

like

Just turned 30 but still feel like college ended only a month ago. Anyone experiencing a similar situation?

like

Any good vegetarian in Bay area?

like

with US blocking aid to Pakistan..India and US allies in new world order ++Japan? against China + Russia + Pakistan?

like

How many years before your 401K vests?

like

Best tech strategy/consulting firm and why? I’ve heard Accenture and Deloitte top the list for larger firms.

like

Thank you Global Entry.

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