Hi,
I have two data sources:
- A list of email addresses for people at my company that have been invited to use a beta tool
- The complete user list and their activity exported from the beta tool
Right now, when I want to see who from the invite list has been using the tool, I use VLOOKUP to extract the data from the beta user activity list. Someone told me that the Index Match function would be a better, cleaner way to do this but I'm not able to get it to work.
What would the formula be if I was trying to compare this. Right now my two table headers look like this:
SHEET 1: INVITE LIST
Employee Name | Email Address | Date Joined | Total Logins | Total Time Spent
(I want to populate the Date Joined, Total Logins & Total Time Spent from this sheet #2
SHEET 2: USER ACTIVITY LOG
Email Address | Date Joined | Total Logins | Total Time Spent | Date Last Login |# of Referrals
I would GREATLY appreciate any help in understanding what the INDEX MATCH formula would be to fill in the Data Joined column for example using sheet 2 as my array. The one field that both sheets have in common is the Email Address.
Tim
Bookmarks