Anyone else use vlookup a lot? There's usually always something I have to fix but I think I've finally gotten the hang of it! Small wins 😌

Post Photo
likesmart
Posting as :
works at
You are currently posting as works at

XLOOKUP all the way

likeupliftingsmart

True story

Wait till you hear about XLOOKUP

likefunnyuplifting
Post Photo
likefunny

Wrapping in an IFNA to handle exceptions and making sure you put the “FALSE” flag at the end of the V/H/XLOOKUP call should make it work 100% of the time.

likesmart

I used to be an index match person but I have since fully joined team XLOOKUP

like

Yeah x lookup is great. Index match has two advantages, but one big disadvantage.
+ Faster (if using 10K plus rows and multiple lookups, this is relevant, and Xlookup is actually the slowest lookup function)
+ Index Match Match is an easier syntax than the row/array lookup of xlookup
- For standard lookups, xlookup has way easier syntax

like

I’m an INDEX MATCH girlie ‘til the day I die - I even prefer it over XLOOKUP

like

Mans been working hard towards mastering VLOOKUP when XLOOKUP has been out for over 5 years

like

Index Match all the way

likesmart

It’s 2024 we XLOOKUP

Index(Match) for the win

likesmart

Touché

That is some quality vintage meme making right there

Related Posts

This made me chuckle.

Post Photo
funnylikesmart

Unfortunately the US CPE course that i pursued was same as the course that i did last year and hence i didnot get credits and became NON-compliant as of june 2021. Can anyone please advise on what to do to become compliant?

like

A few good threads this month. Thanks all for putting it out there

Post Photo
like

Do you feel like turnover has now diminished after this busy season or will it kick up again as we approach the next one?

At this point, I'm wondering if most firms have hired enough people or they are still on the lookout due to shortage.

like

Why aren't there any vegan options in the military besides a salad? I wish there was a way to improve this. I find myself having to settle on vegetarianism when serving.

like

Work hours change scenario: 8hours/day for 4 days per week or 6hours/day for 5 days?

like

Thoughts on the "fake it til you make it" mentality in career growth? Regarding a Front End Developer role.

I passed the HR screen, did an interview with who would be my) supervisor and the team lead, and am now doing a coding test.

I am familiar enough with the language (React) and pushing updates to Git in order to complete the test, but I'm afraid when I do a panel with the team to review my design, I'll end up making a fool of myself.

I've never been so excited yet so nervous for a role.

like

Guy,

How can I get into Microsoft without an MBA in a Program manager role?

I am currently an Associate Product Manager. Overall Exp 4yrs.

Is it possible to get in or MBA is a must...

helpful

Hi guys. What's the status of Microsoft employees in India currently. Any firings going on due to market conditions? Microsoft

like

I had completed 1st year in cognizant here is the situation can anyone please clarify the doubt ..my probation rating is 2 and not good comments and my role is PAT until today my colleagues role changed PAT to PA but my role is not changed why?is it behind the reason about review?

like
funny

Guys ...Is Cognizant a good company to work with ?
Cognizant

like

What questions are asked in KPMG next round after L1 ? Is it technical or totally HR? KPMG KPMG India

like
like

Can anyone please tell me what additional perks (if any) Nielseniq provides? Also, with 2.9 YOE, they are offering 16LPA for 6-2 band. Is that standard or are they trying to lowball me?

like

Has anyone made the switch from public accounting to a tax role at private equity firm?

like

Hey Fishes,

I am preparing for Google Cloud Engineer - AI role
I know there would be DS & Algo, Programming and ML Questions but
I was given a long list of topics to prepare by google - Web/Internet Technologies, Databases/SQL/NoSQL, Linux/Unix, Distributed Systems, System Design, Troubleshooting, Networking
Any suggestions on which topics to concentrate more on ,
any good resources that you can think of and any interview experiences would be very useful, Thanks in advance

like

Do I really need the lectures (Becker) to pass the exams? I really just want to do everything else besides that.

like

Hi,

I am looking for a career transition from a civil engineering( work ex. 3+ ) to Business and data analytics, can anyone advise me with dos & don'ts.

like

Hey all, new to this bowl. Currently a Tech Recruiter and eventually want to make the transition into a HRBP or HR Generalist role. Would love to hear from anyone who started in recruiting then transitioned into another area of HR. Have been thinking of either working on PHR certification or MBA with focus in HR mgt. Thanks!

like

Additional Posts in Excel Genius

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

like

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

How do I compare two sheets to make sure they are identical?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

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