{ "media_type": "text", "post_content": "Is there an absolute moron’s guide to Index Match? I have two tables of users, some exist on table A that don’t on B, and vice versa. I need to merge them based on their email as the unique identifier", "post_id": "5e17819eef3463002f6d5d93", "reply_count": 8, "vote_count": 4, "bowl_id": "5a56f68d15f6ef0013aad256", "bowl_name": "Excel Genius", "feed_type": "bowl" }

Is there an absolute moron’s guide to Index Match? I have two tables of users, some exist on table A that don’t on B, and vice versa. I need to merge them based on their email as the unique identifier

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

Break it down to fewer formulas or steps then figure out how to combine.

1.Build deduplicated list of emails
2. Build index match for table a. If this is hard, first figure out how to use MATCH. The emails not in tableA will give you an error message.
3. Build index match for table b.
4. Embed 2&3 within an IFERROR formula so you can do all the functions in one column.

likehelpful

Bring all of the emails into one column and deduplicate. Then use the email address (your unique identifier) as the key to match. Should be index(user) match (email column, email column,)

helpfullike

I’ve read through a few tutorials and cannot manage to envision what needs to happen. Apologies if this is incredibly elementary but I’m struggling.

helpful

Power Query!

like

Use Alteryx!!

On OSX 😔

Pivot table.

Thanks all for the advice. I ended up breaking it down into steps and using vlookup. Not the most efficient but the brain just isn’t all there today. Really appreciate all of you ❤️

Additional Posts in Excel Genius

Waiting for firms to start posting the processing power of the laptops they issue as a recruitment tool. Would really like PDFs to load.🙄

likefunny

Hi All,

Any opportunity in SAP ABAP ON HANA , Having 1.5 yrs of experience. Please do kindly respond if you know any openings.

Thank you

like

First round at MBB on Friday, any tips?

like

Pakistani 🐠 - what does "Riyasat - E - Madina" mean ? Saw the phrase in the previous post about IK and Google/quora is giving dumb answers

like

Hey Everyone

Please suggest if Motherson sumi infotech of Noida location is a good company to join after 7 years of experience

like
like

Digital Strategist with 3+ years experience, NYC. How much should I ask for?

Hello everyone am looking for Side hustle , anything works driving ,plumbing ,construction etc anything works just hit me up and I I’ll make time to get it done for you thnx 💪

likehelpful

Is citi a good company for me to upskill myself ?
Currently working in a small firm where i take care of a small project all by my own. Will citi map me to a legacy project?

Skill: java , sprinboot etc
Yoe:3 years

like

Ladies! First time getting Botox. Recommendations in NYC? Thanks.

like

Anyone hear anything from Yale today?

like

What does it mean when someone makes eye contact only with your partner but refuses to make eye contact with you, even when you ask them a question? Always wondered this through the years...

Sometimes I am frustrated with the slowness of our tech development...how does working fast failing fast apply when there are so many iterations...

like

What's market signing bonus for 4th year associate (corporate) in NY these days for K&E or Latham? What's the max you've heard of this year?

like

Currently have one offer for 145k plus 12%bonus and should Decide by monday morning. One verbal offer for 150k plus 12%bonus. Verbal provided last wednesday and the offer approval is taking very long. The first is on Azure and second one is more like a manager role with dev teams in India. What should I do?

funny

Trying to sell 2 TVs...

46” Samsung
32” Vizio

Price negotiable. Facebook Marketplace hasn’t had any hits.

like

BBH or Wieden right now?

Choosing between industries for Big 4 Audit. Asset Management or Technology Media and Telecommunications to transition into TAS down the line for Major Metro Markets?

like

How does the new political landscape post mid-terms impact legal immigration legislations?

Has anyone questioned their choice of partner leading up to the egg retrieval process? Mine has been really unsupportive lately. Got mad and said we should split up last week, keeps calling me crabby from the hormones, etc. It’s to the point I want to see if I can just keep my eggs on ice since I’m going through the process anyways and move on with my life. My best friend told me not to make any huge life changes. Is this amount of mood swings normal?

like

Additional Posts (overall)

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

Silly question - what’s the difference between the 0 and FALSE in the following VLOOKUP(value,table,column reference,0) and VLOOKUP(value,table,column reference,FALSE)

like

What task would you expect excel of being able to do but you have never been able to make excel do it.

like

Just got a dell and getting annoyed learning new shortcuts on excel (had HP prior) - how do I automatically get to cell A1? Used to be CTRL-HOME on HP and Lenovo

Post Photo
like

I have a master data list on sheet 1. Need to split the data by location (4 locations) on other sheets but only want to update sheet 1 as I get more data. How can I make it so?

like

How can I index match a relative value?

I want to look up the per unit cost of 280M units, but don’t have an exact match. The numbers in the picture below are actual units/infra I’m searching against

My formula is currently =index(D26:D48,match(B56,B26:B48,1)

Post Photo
like

I have about 10 variables each with a certain score (10,14,15, 20,20,20,7,9,2,1). I need the max value is there is a single winner (MAX function work here.) If there is a tie for the highest score, I need an output that says “Multiple.” How would I go about this?

Thanks in advance!

like

Happy Friday Eve

Post Photo
likefunny

Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.

If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.

Thanks in advance

like

Also posted in data analytics bowl, but quick question. I am looking to use Tables 1 and Tables 2 in this screenshot to yield the “ideal outcome” table in Power BI (using query editor). The tables I have setup look similar to Table 1 and Table 2 (it’s a mapping activity of controls to various categories). Is anyone familiar with the proper steps / video that will help me arrive at the ideal outcome?

Post Photo
like

Trying to figure out how to understand the variability of price data along a downward trend. Any ideas? If the data wasn’t trending, I’d just evaluate the distribution of data, maybe normalize it.

When I try to reference a cell in my formula, it won’t let me even click on it and I get the error “There’s a problem with this formula. Not trying to type a formula? When the first character is an equal or minus sign, Excel thinks it’s a formula”

like

What’s the next step in better pay as an HR Coordinator? I’m currently picking up a data analytics certificate for fresher skillsets. I’m aiming for $80-$90k salary at the moment.

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

Hello Excel Geniuses- I need help. I have never learned macros but I’m about to but before I invest the few hours or however long it might take, I wanted to find out if it is possible to do what...

likehelpfulfunny

Looking to do data analytics for nonprofit organizations. Any forms or websites to look?

like

Any ideas on how to sumif based on criteria listed under a given header wherein the header is the main reference but there are varying criteria beneath said header? Specifically, I would like to drag a formula down a column that references a corresponding department in the row (the header on a sep sheet) and then sums the listed accounts beneath each dept (with each dept having a diff # of accounts) from a given data set. Could do a pivot, but the filtering process is inefficient.

like

Hey everyone, I'm looking to get some help tracking product sales for my business. I have an excel sheet, but it still needs some work. Can anyone help?

Thanks

like

I have zip-zip routes for a trucking company. Most of them have price info but some are blank. Is it possible to do a count of those with price and without price in two columns of a pivot? I want to show that prices are missing across the board and that we can use the majority to replicate the missing few.

like

What’s the best resource to learn how to do a complete DCF valuation?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
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

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

New to Fishbowl?

image with Fishbowl logo and arms reaching out for a handshake

Already have an account? Log in

By continuing you agree to Terms of Use and Privacy Policy.
Messaging rates may apply

For account settings, visit Fishbowl on Desktop Browser or

General

Legal