• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to extract one column value exists another columns without blanks

m9vukyem

Member
please find attchment
 

Attachments

  • Check if Cell value exists in Column, and then get the value of.xlsx
    9 KB · Views: 6
In C2, copied down :

=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW(A$2:A$9)/(MATCH(B$2:B$9,A$2:A$9,0)>0),ROW(A1))),"")

76172
 
if the list a and list b is different area (i.e list a 15 rows and somewhere in the sheet and list b is 10 rows and not opposite to list a) not getting that result.
 

Attachments

  • reco.xlsx
    172.8 KB · Views: 2
Back
Top