LinkBack URL
About LinkBacks
Hello Friends,
I am looking for Vlookup function, which returns multiple values without duplicates. For clear understanding I have attached sample file. Please find the attachment. Hope someone could help me.
Regards,
Srikanth k
Hello Friends,
I am looking for Vlookup function, which returns multiple values without duplicates. For clear understanding I have attached sample file. Please find the attachment. Hope someone could help me.
Regards,
Srikanth k
In F4:
=IFERROR(VLOOKUP(E4,$B$4:$C$13,2,FALSE),"")
copied down
in G4:
=IFERROR(INDEX($C$4:$C$13,MATCH(1,INDEX(($B$4:$B$13=E4)*($C$4:$C$13<>F4),0),0)),"")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi NBVC,
With reference to the sample given by srikanthk, if the Result for Value are more than 2 data, how the formula works?
Thanks in advance.
Rgds
Thank you very much for reply, this what exactly i need. My problem has been solved.
Regards,
srikanth k
Re: Vlookup for multiple results without duplicates
Hi All
I need a formula to return the duplicate value
for more info please see attachment.
IT IS VERY IMPORTANT FOR ME
best regards Ahmad
thak you
this resolve my proplem
Unfortunately last posts do not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Best Regards,
Kaper
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks