The data from group C4 is coming from cell V7 on the "MASTER" sheet. C2's data is coming from cell V6 on the "MASTER" sheet. In the "Groups" sheet, Chaverim 2 (C2) shows in cell H7 that SC or soccer in being played period 1. The formula =HLOOKUP(G7,MASTER!V4:AL9,3,0)" is pulling the activity data from the "MASTER" sheet. H18 then shows "Soccer" using the formula =VLOOKUP(G18,G31:H80,2,0).
In the case that two groups are playing each other, I would like the cell (in this case H18) to show "Soccer with C4" instead of just "soccer.
On the "SC" sheet, cell H6 pulls the group data from the "MASTER" sheet by using the formula
Cell H17 uses formula =REPLACE(H6,1,2," ") to show "C2" in the cell but when two groups are playing each other I would like the cell (in this case H17) to read "C2 vs. C4".
Hope I am making more sense Jason.
Appreciate your help!!