Vlookup but with unique values

[Jovinchious]

Hi guys,

i ll need a bit of help.

i want this formula in "LR" column "=IFERROR(VLOOKUP(C2;Sheet1!$A:$E;5;FALSE);"")" to give me only the unique values, so for example, if it returns number "9900007055" in cells LR4 and in LR5, thats no good...

so, basically i have a lot of the same names in C column of sheet2 and A column of sheet1, but with different number in E column of sheet1, and Vlookup gives me only 1 result and copies it all over the column...but i need a unique numbers.

chatGPT does not help with this one :D
Thanks in advance!

Luka

 

[etaf]

what version of excel , is this still 2007????
UNIQUE() & FILTER() are in later versions which should do what you are after

 

[AhoyNC]

It would help if you post a small sample and the expected results. With Excel 2007 it will probably require a complicated array formula using INDEX and FREQUENCY functions.

 

[Jovinchious]

got it. thanks guys...
heres the solution:

=IFERROR(TEXTJOIN(";";TRUE; UNIQUE(FILTER(Sheet1!$D:$D; Sheet1!$A:$A=A2)));"")

its for other columns...but the same thing.
after that, just make text to columns via ; separator and thats it. Thanks!

 

[etaf]

thanlks for takling the time to reply with the solution, not everyone does here ,

however, it would be useful if you update your profile with the version you are using , would have had a much quicker reply as members here would know you can use , filter and unique etc
as i posted