which formulae do i need to apply

[villival]

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

 

[pecoflyer]

Please post a sample sheet

 

[srinidhi]

Vlookup will get you the required results

 

[villival]

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

 

[villival]

Vlookup will get you the required results

i tried everything but i vain

 

[bosco_yip]

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

 

[pecoflyer]

i tried everything but i vain

Please post your results so we can help you correct what went wrong?

 

[srinidhi]

used =XLOOKUP(A2,status!C:C,status!B:B) , if you have office 365.