Apr 19, 2010 at 08:07 AM
Posts4478Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022
Apr 19, 2010 at 08:12 AM
I have tabular outputs of two data sources and I need to match the data together.
Each set contains two columns and can be pasted into one sheet and would like like such:
UserID BankID UserID Cluster ID
I need to find the BankID that matches the ClusterID linked by the comon UserID. All of these values contains a mix of text and numbers. Is there a formula that I can use that would match the UserIDs and write the BankID that matches the ClusterID? I've been searching online and fiddling with Excel for days now and would really appreciate any help I can get.