populate  date columns with corresponding fixtures

mikes6058
mikes6058 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Saurabh Singh Teotia
Top Expert 2015

Commented:
Your data wasn't Clean as in the team names had spaces and all and at time special char..

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
Top Expert 2015
Commented:
Their you go i further cleaned your data since once city was messed up in your sheet..Now this will gives you the results even for that..

Saurabh...
fantasy-football---predicter.xlsx
mikes6058

Author

Commented:
Fantastic, great work!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial