mikes6058
asked on
populate date columns with corresponding fixtures
I'm trying to populate columns G:AU on the "fixtures" with the corresponding fixtures found on the "fixtures rows" sheet.
I have manually entered the first 4 results (highlighted in yellow) to demonstrate. Every cell in every column should have a result.
E.G. on the 8th August 2015 the following fixtures took place
Chelsea v Swansea City
Manchester United v Tottenham Hotspur
Manchester City v West Bromwich Albion
Arsenal v West Ham United
This needs to be repeated for every row.....
all the fixtures with dates can be found on the fixtures rows sheet.
I can't find a quick way of doing this.
If someone can it would be great, please attach
Good Luck!
Mike
fantasy-football---predicter.xlsx
I have manually entered the first 4 results (highlighted in yellow) to demonstrate. Every cell in every column should have a result.
E.G. on the 8th August 2015 the following fixtures took place
Chelsea v Swansea City
Manchester United v Tottenham Hotspur
Manchester City v West Bromwich Albion
Arsenal v West Ham United
This needs to be repeated for every row.....
all the fixtures with dates can be found on the fixtures rows sheet.
I can't find a quick way of doing this.
If someone can it would be great, please attach
Good Luck!
Mike
fantasy-football---predicter.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Fantastic, great work!
I cleaned it and apply a formula which does what you are looking for..
Where it doesn't find a match it shows a "-" sign..
Enclosed is your workbook for your reference...
Saurabh...
fantasy-football---predicter.xlsx