Vlookup to update the duplicate results in list(data validation list)

**cheTAN kc** · 05-16-2017, 03:22 PM

Hi,

I am looking for a vlookup help, I have a huge data in which multiple items are duplicate. And vlookup helps to identify only one result. Is there any way to make the vlookup result appear in list( like data validation list). so that all the possible duplicates appear in the list wise.

I have one example in the below link.

when I enter the data in the Column-F2, with 7600000, using Vlookup can the same type of list format in Column-B2 appear in the Column-G2 in the same list format?

Please help me.

https://www.excelforum.com/attachmen...1&d=1494961562[/B]

**p24leclerc** · 05-16-2017, 10:06 PM

you can use this formula and copy it down for an amount of cells so that you'll have the duplicates. At least, till the formula returns a result.

Please Login or Register  to view this content.

As this is an array formula, you NEED to end its editing by pressing CTRL+SHIFT+ENTER at the same time. You should see curly brackets appear around you formula.