VBA to match and sort data in two columns, then copy to another two colums

Hello Kaper, thank you for you fast response and helping me to look at my problem.

Apologies if I have over simplified my explanation below.



The attached workbook contains the actual data that I have (by VBA) copied data from an external website, cleaned up and removed rubbish, called “Data” sheet. The “CF” sheet will be the final output.

I am trying to get the “data” sheet into a state that VLOOKUP on CF sheet will fill in the blanks.

“Rowville Rockets” is a junior basketball club. “B9 Red” is a team my result is to know when, where and I will be happy if we get all but the duplicate Rowville Rockets teams to work.

In my “Data” Sheet, columns C:K contains the imported data. The populated rows in columns A and B is examples of mock results.

Basically all “Rowville Rockets” teams in column A, opponent or “Bye” in Column B. We may have to error on 2 “Rowville Rockets” teams.

I am wondering If I have overlooked a simple method.

Thank you for your help.
P1w2