Index Match > Vlookup

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

Xlookup all the way

likesmart

All 8 of the Xlookup Stan’s coming out of the woodworks

funnylike

<Xlookup

like

Only if needed. Vlookup otherwise is so quick and simple. I don't have to do mental gymnastics to remember what to put first.

like

D1...I've never had to count, Excel shows you the count as you drag if you're doing it through the formula bar and not using the formula helper.

BIG FACTS

smart

Someone get their analyst

like

Wow

And the pope 💩 in the woods

Xlookups can look up right to left and bottom to top.

Xlookup

Oh boy…. Power query is the way to go here

Related Posts

𝐃𝐚𝐭𝐚 𝐈𝐧𝐬𝐩𝐞𝐜𝐭𝐨𝐫 - 𝐓𝐡𝐞 𝐒𝐄16 𝐟𝐨𝐫 𝐒𝐀𝐏 𝐒𝐮𝐜𝐜𝐞𝐬𝐬𝐅𝐚𝐜𝐭𝐨𝐫𝐬!!

A data inspector tool for professional user to check raw data. Perhaps, it's a one-stop destination to report various entity tables which were earlier accessed from different tools in Employee Central, allows you to view/ download the raw data in a tabular from the instance.

Use Case:
* display the list of frequencies available in the system - Entity: FO_FREQUENCY

Post Photo

Hi there,

I’m thinking of a career move. Does anyone have experience of AD roles at either McCann Health / Ogilvy / RAPP Well ? Keen to understand the culture if possible. Thanks

like

How do you deal with teammates who don't take initiative or move things forward on a project without being told to do so?

We have a deliverable due on Friday with alot of things to get done before then and seems like no one cares? I ask for status updates and all I get is no, haven't done that, will do it now. Sure enough, ask next day and the response is no, haven't done it yet.

These folks are seniors as well. Partner looks to me to provide a status update, and all I can say is in process.

like

Brigsby would like you to know that shoes are the preferred cat bed, not BAGS, /Julius/

Post Photo
likefunny

Quick question, Is EB1 multinational manger experience considered any country outside of USA or it should be inside your home country. Need your suggestion.

Found out today my toxic manager bad mouthed me to an HR rep in a different division. This correlated with his bad management and abusive behavior. Luckily the new manager I’ll soon be working with dismissed it. Her words of wisdom “reflect on what you could have done differently, you can only control your actions”. How does that resonate for you? Have you had similar experiences?

like

Looking for advice on how to move into advisory and if it’s recommended as the primary caregiver for 2 young children in regards to WLB. I have been in financial services audit for 5 years and it really isn’t a fit for my personality. Have a BS in accounting and CPA, do I need to go back for an MBA?

like

Hi all,

Looking for a 2bhk fully furnished flat nearby kharadi area/ viman nagar.
Any leads would be highly appreciated.

11 like for Dm.

likehelpful

Do anyone know about McLaren Strategic ventures.
Please comment

like

Hi Amazonians,
I am looking for guidance.

I am going to start interview process with Amazon next week. Probably all rounds will be done in 1-2 day time frame.

How/what should I prepare for interview?
Am clueless on what kind of ds & algo questions, system design questions are asked in Amazon interviews.

My techstack: javascript developer- react+Angular.

1. Pls guide me on what/how to prepare?
2. Also, will the interview be solely on da & algo and javascript; or on Js frameworks?

Amazon

like

So I am at my first job after college. They lied about a lot of things. It is not diverse, it is not inclusive. Other issues is the management is clueless and I’m contemplating weather I should start looking for other jobs after only being here for 5 months. I would have to pay back relocation and bonus unless I stay here for 2 years. Any thoughts? I need advice on this

like

What is the salary range for level 11 Security Analyst in Accenture?

like

Hello all. My company just went through an acquisition and the company did some restructuring of job titles. When they did this we were all advised the company would be making sure our jobs pay aligned with the national average.
My issue with this is my job title went from a Technical Support Supervisor to a Customer Success Team Lead. I have voiced my concerns with management but have been advised job titles are semantics. In my eyes this is a demotion, and will affect how much my job is worth.

I got through all the rounds of interviews (including 2 technical panels) at CrowdStrike before being assured that I was nearing the end of the process and was expected to receive an offer soon… almost two weeks ago now? Anyone else experienced this kind of delay from CS or similarly sized organizations? Did I get ghosted? Anything more I should be doing?

like

Is there any difference in salary between Deloitte and KPMG? Just curious. Thinking to move to KPMG

likesmart

Sitting on my work desk and staring at the monitors! - Thinking deeply - Is this really what I wanted to do in my life!……. just woke up from a Nap 😆

likefunny

Hi, I have got an offer from HSBC at Analyst - GCB 6 for Business Analyst Role where the job title in the letter is given as Analyst.

I wanted to check if anyone who works in HSBC Global Transformation team can help me walkthrough the structure and the work culture in it.

like

Additional Posts in Excel Genius

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

how do you index or vlookup when the match isn't exact? like one cell has a comma or space after the value...?

like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

Post Photo
like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Anyone know if / how to have the CapIQ and SNL (MI) excel plugins running at the same time? I always run into issues with one of them not functioning when they’re both enabled

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
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