Does anyone know if it’s possible to return multiple values using a vlookup or index match for duplicate values?

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

Is this something pivoting out your data wouldn't be able to give you what you need? For instance one product name has multiple SKUs associated, pivot that data out and you'll see all SKUs associated to each product. Or identifying a unique concat to index match values to?

likehelpful

I usually create a new unique identifier when duplicates may exist. So make a new column and make it =a2&b2&c2

Use as many cells as you need to create all unique identifiers. The conditionally format for duplicates to make sure you have the desired result.

like

Yes what Consultant 2 said. You could do an array formula, {=INDEX(A:A,MATCH(B1&C1,D:D&E:E,0))} but it will be supppppeeeerrrr slow and bog your file down. So best to make new columns to concatenate it together to make a primary 🔑 and index/match that, or another method

like

Why not use countif and then you can filter out the ones for which its greater than 1

like

Definitely make a new identifier - there is a way to do this with index match without another identifier but it is super messy

like

I mean anything is possible but you will have to provide more detail. I'll make a burner email tonight and I can take a look but you'll have to send me the workbook and a description of what you're trying to do

Index match, yes but it will slow your file down.

Quickest method is definitely Pivot Tables. I’d make the pivots, then copy into new tables and create new IDs from there.

This will be an array formula and it will go slow

I have to do this all the time...just pivot on dat

You can add offset to your lookup if the duplicates are next to each other.

Related Posts

Renting out my townhome 3 bed, 2.5 bath, 2 car garage in a great location and neighborhood, only 15min from LODO / downtown / highlands and close to all major highways to get to the mountains. Furnished and looking for long term rental. Landscaping, trash, and snow removal covered. DM me for details if you're interested.

like

Ways to buy more time when negotiating contract for new job? Got a live offer for several reasons need to stall.

like

How is everyone doing with the current situation?

Does anyone have a handyman and/or painter they would recommend? Looking to get some work done on my condo in the loop - change some appliances, lighting, paint etc. Thanks!

like

I’m new to this… if my company offers maternity leave, do I still have to apply for FMLA? I wanted to take 4motnhs off but seems like fmla only covers 12 weeks and my company also offers 12 weeks of unpaid leave

like

The incredible bravery of these people.

Post Photo
like

Hey guys! What a great app and space! I’ve been wondering how long I should hang onto this technical recruiter role at 55k salary plus commission . I love my team, the resources and training , PTO, etc… but, I’m underpaid for sure. I got involved with this agency for the training and notoriety. When should I jump ship and which way should I go to make the most $$$ with work/life balance. ??? I know it’s a broad topic without more specs but general answers will do. Thanks!

like

Why Asians like xrp so much?

Hi all. Looking for advice. I’m trying to decide between 2 job offers (same salary) but different positions. One is a study director (essentially a project manager for a medical device company) and the other is in Quality Assurance (medical device company as well). Study director position company is slightly smaller but growing. I really want growth possibilities and a good career future. Any advice?

like

One of my friend wants to start a career in devops so asked me what tech stack he should start learning ? Can anyone having an experience in devops plz answer ?

like

400K USD family income in US (Washington DC) or 1.1 Cr in India (Bangalore)? What’s the cost of living like in Washington DC?

like

Has any one tried affiliate marketing? I want to start a side gig on the weekends and this keeps coming up.

like

Anyone here ski? I drunkenly bought an epic pass and am in the final stages of lateraling to a MM/BB coverage. How dumb of a move was that purchase / will I be able to use it? Was able to go quite a few times at current bank as an analyst

like

Just curious - why would an agency hire a freelance ACD? Wouldn’t it make more sense to just hire the person?

like

Will HIPAA change for telehealth during a pandemic?

like

any insight on severance packages from ACN? joined in july, been on the bench since, feel like it isn’t necessarily imminent at this point, but figure that i should begin to prepare mentally jic

like

Hey all for anyone looking to drop by, we're located at the long table on the far side of Pier 17. Near the Ferries to Brooklyn and Queens and a short walk from stations Fulton, Wall St and Cortlandt.

Post Photo
like

Can anyone please refer me to @Mastercard for Requisition ID: R-177325

like

Need Referral🙏

Just a week left to find a new job.🥲🥲
I was asked by my previous employer to look for a new opportunity in just 3 months after joining due to no projects. I was given 28 days to look for a job in which i tried my best, only got 2 interview calls but both HR ghosted me after clearing 1st round.

Skills - Data Science/ML, DL, NLP, Python,SQL, Aws and snowflake.
Yoe -2.5

Request anyone with relevant opportunities to please DM me.

Prefered location - Remote, Pune, Banglore.

like

Additional Posts in Excel Genius

Is there a way/shortcut, without using a mouse to drag cells down, to fill a range of data following a trend? I want a column with the first day of each month up to a certain date (row number). Thanks

Help this is probably dumb. I have a workbook with 30 tabs. Is there a quick way to separate each in to its own book or should I copy one a time?

like

I’m trying to consolidated planning of FTEs from weeks to fiscal periods in a new table. If my column heading in the original table is 1, 2, 3 etc and my new table is Period 1, Period 2 etc
What is the most efficient formula to do this? Just doing =sum(Hours!E7:H7) for each period will take forever… thank you!!

like

Hi, in my excel pivot table slicer I have my options and then (blanks) option , anyway to get rid of that?

I’m looking to make a supplier list where I can just filter on certain requirements to get a smaller list…currently creating as a pivot table but is there any other options that make sense?

Post Photo
like

I have to revert a scale of 1-13 to 1-5, any advice on how to do / automate this? TIA 🙌🏽

like

Story time: I was on a trip about 15 years back, doing some Excel work on a ferry ride - your basic pseudo-database work that is so common. I started talking with the guy sitting next to me and after a while he commented on what I was doing, “You know, that’s really not what I designed that for…” (continued)

likefunny

I can finally use index match. I feel like such a genius

likeupliftingfunny

Anyone know of an Excel plugin that acts as a reference calendar for Federal Reserve holidays (and those observed)?

like

How would I create subtotal rows in a table? A true table, I dont want to turn my table into a range because I need the other sorting features.

likehelpful

Anyone kind enough to help me start a PE fund model with a waterfall.
Struggling to get started.

like

Which add-in does your firm use for formatting charts? We use ‘thinkcell’ to create and format charts. Not sure if it’s the best add-in to rely on?

like

Does xlookup take more processing power than index match or is it negligible?

like

In VBA when sending an email. How do I change the reply to email?

like

Hello All,
Excel help please. I’m trying to combine 3 tabs into 1. So on tabs a,b,c I have wire instructions that go to different places, but they all have the same field names/format. However the number of rows for each tab will vary from day to day. I need to make a fourth tab that shows all the rows from a,b,c consecutively. Because the number of rows change, I can’t find the best way to collate all the rows into one table. I can use a macro or lookups or a source formula. Please advise!
Mo

like

Anyone have thoughts on best VBA/macro training out there? I find there are so many things I could automate and need a good place to learn the basics (particularly for excel).

like

Does anyone know if Excel is compatable with Adobe Sign/PDF? I'm trying to automate data entry from Adobe sign/PDF to an Excel sheet. Adobe

like

Hey Geniuses,

I’m looking to teach myself how to build financial models and LBOs for some PE interviews. Do you know of any free or reasonably priced resources I could use?

like

My excel columns have switched to numbers (so I know have numbers for columns and rows). This has also made all of my formulas incredibly confusing. Was this part of some update? How can I switch my columns back to letters?

like

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

My Goal: I have a drop down menu in a cell. I want it to sort conditionally based on what I select. Is that possible?
Ex: If the drop down ="done" it falls to the bottom of the list.

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