VLOOKUP

[ushaanu]

HI All ,

I need help on one excel data which having different data against unique value. now in other file when i put vlookup against unique value pick only first row value but need all row value. like

ABC 123
ABC 456
ABC 111

thanks Anu

 

[AliGW]

Which version of Excel are you using?

 

[ushaanu]

Which version of Excel are you using?

XLSX

 

[bosco_yip]

Using a helper column, can easy solve the problem for all Excel versions.

1] Helper column, A2 formula copied down :

=IF(B2="","",B2&COUNTIF(B$2:B2,B2))

Then

2] In Result, F2 formula copied down:

=IFERROR(VLOOKUP(E$2&ROW(A1),A$2:C$100,3,0),"")

 

[pecoflyer]

XLSX

xlsx is a sheet format, not an XL version. That is something like 2010, 2016 O365,...
If, e.g. you have O365, the FILTER function will do that for you quite easily, that is why Ali was asking