This is a spreadsheet for tracking pairings in a couples golf league. The Pairings sheet has the date in column A, and the pairings in however many columns that there are teams. On the Calcs sheet, column A has all of the possible pairings, and column B has the count of how many times each couple has been paired together. I would like to have column C out (Calcs sheet), bring in the all of the dates that each couple has been paired together. So if A and B played together on Dec 22nd and Jan 26th, on the Calcs sheet, I would like C1 to be Dec 22 and D1 to be Jan 26. I have looked at VLOOKUP and INDEX/MATCH until I have a headache. Thank you in advance for any help.
Bookmarks