• 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.

which formulae do i need to apply

villival

Member
I have an excel list which contains two sheets
  • Sheet 1- This contains list of subscribers their email ids
  • Sheet 2 -contains their activity (i.e.Usubscribed,Subscribed,free)
  • I want to find out list of un-subscribers from list 1 using email ids
Thanks
 
Vlookup will get you the required results
find attached Sample sheet in 1st sheet it contains email of subscribers , 2 sheet contains email and has a column which has subsribed.unsubscribed
  • I want to find out list of subscribers from list 1 using email ids
 

Attachments

  • samples.xlsx
    12.7 KB · Views: 5
1] Unmerge all columns with merged cells

2] In B2, enter formula and copied down :

=INDEX(status!$B$2:$B$24,MATCH(A2,status!$C$2:$C$24,0))

3] Please see attachment

80180
 

Attachments

  • samples(BY).xlsx
    14.2 KB · Views: 4
Back
Top