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.