Hi, I'm trying to look up values where duplicates exist but do not want the same lookup value to be returned. When I use Index/Match, it returns the first like value it finds, so I'm ending up with the wrong reference. Can someone help? I'm attaching an example with the formula I was using.
Thanks in advance!
Book3.xlsx
In A8, hit with CTRL+SHIFT+ENTER not just ENTER.
=INDEX(A$3:I$3,SMALL(IF(A$4:I$4=B8,COLUMN(A$4:I$4)-COLUMN(A$4)+1),COUNTIF(B$8:B8,B8)))
Then copy down.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Fantastic, thanks a million!!!
With a helprow i get this solution.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks