Extraction of Duplicate Data Entries using

[Ela01]

Hi Guys,

I needed some help is extracting the entries in Column 2 using the ref as Column 1.

The column 1 has duplicated entries and vlookup will return only the first entry. Can someone help?

Thanks

Column1__Column2
ID_________Data
C18S950_23 App
C18S950_28 Napp
C18S950_28 wap
C18S950_50 zap
C18S950_50 app
C18S950_54 Napp
C18S950_65 zap
C18S950_67 pap
C18S950_77 rap
C18S950_80 hap
C18S950_85 fap
C18S950_93 lapred
C18S950_93 sdf
C18S950_93 grg


I

 

[bosco_yip]

Please check with this post regarding formula for Duplicated Criteria Lookup

https://chandoo.org/wp/2014/11/10/formula-forensics-no-003b-lukes-reward-part-ii/

Regards
Bosco