Additional Posts in Excel Genius
First round at MBB on Friday, any tips?
Anyone hear anything from Yale today?
Additional Posts (overall)
Happy Friday Eve

New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
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.
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,)
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.
Power Query!
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 ❤️