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?


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.


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


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


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


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

Koi bhai behen mujhe refer kr dega? Notice period chal raha hega apna
Yoe 7
tech stack Java ds algo system design
LWD 6th May, 2022


Respiratory Therapist Salary in NEW MEXICO.
Please add years of experience please?
I'm just curious, thank you all!


The zombies are out today and hungry. Except, it’s 4/20 and they may not find what they’re looking for.

Post Photo

Will EB-2 dates reset in October for Indians and back to current for ROW? And when is bulletin usually issued for October?


What kind of multiples is used by buyout and growth equity investors (e.g., Hg Capital, Summit Partners, TA Associates) to value SaaS companies? Do they only rely on EBITDA multiples or use ARR/revenue multiples as well?


Hi fishes
One of my friend looking for a job,
He lost his job in this pendamic by layoff, if possible pls refer
Position: General accounting ops analyst (bpo)
Exp: 6 yrs


Consulting makes me feel very anxious + stressed all the time. I feel extremely nauseous constantly. Anyone else feel this way?


Wondering what you would do. Cuban dad, white/British mom, dad didn’t speak Spanish in the house growing up. Somewhat Hispanic features and only speak the language some. Definitely love my Cuban heritage with food and music, and my kids respect that too. My birth certificate says Hispanic. Should I identify as Latin/Hispanic in a job application? I feel it’s appropriate but feels a little culturally appropriating. I’m not applying for anything at the moment.


Are there any partners who had deep IT/ technology delivery experience . How was your experience in moving up? I have pretty strong tech skills for a SM and have been told my soft skills are (contd.)


Should i focus on becoming a FrontEnd developer or a Web developer?


Looking for referrals to OECD France or any European branch. Anyone working at OECD, I would be grateful for your guidance.


Can anyone help with a referral in Genpact for PD/MT role in finance. I have completed Bcom and currently pursuing a distance MBA in finance. Experienced in BPO/KPO industry and iam proficient in advanced Excel and SQL. Thanks in advance. Genpact


What certifications do you recommend getting to help your career and make you a more appealing job applicant?
I have my PHR.


What’s the per diem at Deloitte? Does it cover lunch?

Hi Fishes,

I am looking for opportunities in CRM Product domain.
YOE: 6 Years

Any referrals would be appreciated.

Thanks in advance.


I’m so tired of US companies hiring remote Canadian employees offering to pay a fraction of the price for the same role.

This is consistent across the majority of the tech companies. While I am looking to exit consulting, don’t want to be paid 50% of what my colleagues would be making across the border.


During negotiations, what other perks/benefits besides salary do you like to bring up to arrange?


Trafalgar is confused. Can't be trusted

Post Photo

God Bless the owner of this bowl to help throw light on cringe that gets floated around in LinkedIn.


Additional Posts in Excel Genius

Pivot keeps changing my dates from m/d/y to D-month. Whyyyy


Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted


Is there any way to generate a summary of comments or view all comment for a workbook?


Trying to use Power BI for variance analysis and actual vs forecast comparison. Anybody have any tips/resources to help get started on this as a newbie to BI?


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.


What’s an effective way to learn alteryx and tableau? My team always uses the BI team to do workflows and never gives me chance to learn the software.


I’m comparing balance amounts YoY and calculating % change. How do I prevent error messages in the % column when amounts were 0 last year? (cause you can’t / anything by 0)


How do you convert an excel table to an SQL database?


Urgent 🥲 How to show a low to high range on a graph in thinkcell? Any ppt or excel suggestions will work


Anyone else jump to conclusions about a person’s competence simply by the number of merged cells in their workbooks?


How do you get SORTBY to ignore empty cells? I have a dynamic array that changes the number of rows based on a cell’s lookup of the criteria from its data validation list. Accordingly, I need to run the SORTBY range set to the longest possible list, but when a criteria from the DV list “shrinks” that output list, the SORTBY evaluates the now-blank cells to 0 and places them at the top before sorting the list per the ascending or descending criteria established within it’s equation.


Does anybody have a good resource that would let me link data from QuickBooks Desktop to Excel?


How come an empty column and row are usually added to the top left of the spreadsheet? Is it for navigation purposes?


What’s a good place to start learning excel?! I know the basics whatif, vlookup, etc. but I’d like to become better at it. I learned in school and never applied much of what I learned in my professional career so now I feel a little behind.


Hello Excel Experts! Are there any online LIVE Excel classes out there with LIVE instructors? NOT INTERESTED in a pre-recorded class or YouTube class.


How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo

Best way to pick up LBO modeling? Recommended resources, tips, tricks are appreciated


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


When using a calculated field within a pivot table with the following formula: IFERROR(GM/‘Total Sales’,”-“), my values still return a VALUES error. I tried adding an additional parenthesis but no luck


Anyone know how to read xlsb. file in Alteryx. Currently using 2021.01 version.


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


Embed this post

Copy and paste embed code on your site


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


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