Vlookup with duplicates

**JTDarkmaster** · 01-22-2021, 05:27 PM

I am trying to create a sheet where I can return values based on the search criteria but avoid it simply returning the same entry multiple times. I have a list of companies so when I search company A I need it to show me all the entries from company A and not just the highest company A on the list. Not sure if that is worded well but there is an excel attached which should make clear what I mean. I have manually inputted the desired output as a demonstration.

I did try to utilize Vlookup as well as Index and Match, but I couldn't quite workout how to get it to return each unique entry as opposed to duplicating the first match.

**AliGW** · 01-22-2021, 05:30 PM

Administrative Note:

Welcome to the forum.

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

**JTDarkmaster** · 01-22-2021, 05:35 PM

Thank you,
I have updated accordingly.

**AliGW** · 01-22-2021, 05:45 PM

As you have 365, look at the new FILTER function: https://exceljet.net/excel-functions...ilter-function

**Glenn Kennedy** · 01-23-2021, 04:30 AM

1. Delete your expected answers.

2. Use, in B3 copied across and down:

=FILTER(Contractors!B$2:B$30,Contractors!$A$2:$A$30=Search!$A$2,"")

If you don't delete the expected answers first, you will get a load of #SPILL errors.

**AliGW** · 01-23-2021, 04:51 AM

If you don't delete the expected answers first, you will get a load of #SPILL errors.

Doh! That's why I couldn't get it to work ... Lesson learnt.

Vlookup with duplicates

LinkBack

Thread Tools

Rate This Thread

Display