check users

Hi All,

Can someone please help to find users who are using same channel to book orders

In our environment user book orders from two channels mobile and web

Now we have new applications added as channel (iphone and android) in our database

So Now i would like to know users who have booked orders using new channel iphone and web are the same users who booked orders from mobile and web

The workbook I am attached does contain only sample data and does not have new applications added

Hence we can use the existing channels mobile and web to see who are the users using both the channels

I think may be this can be achieved using Lookup function or isnull but was unable to figure out how

Can some one please help me on this

Thanks in advance

Regards,

Praveen