Hi, I have posted this elsewhere but have so far got no success in getting some answers, so hoping here will give me more success.
I have in a sheet titled 'Prem 15-16' with every fixture for the English Premier League from the 1st day until the final day. Dates in this page are listed down column B.
I have, in a second sheet in A1, a date that I manually insert.
What I am trying to do is to populate in cell A5, A6 etc down the fixtures for the date in A1.
So, for instance, I have 12th March in A1, in A5 I should have Arsenal V West Brom, then in A6 I'd like it to be Aston Villa V Tottenham, A7 will be Bournemouth V Swansea and so on. My only issue at the moment is that if I write a simple IF statement, it gives me an error as it has more than 1 answer and I can't bypass an 'answer' already given. And vlookup only gives me 1 answer when I could have up to 10
Please help
Bookmarks