Hi,
I was wondering whether someone can help me out?
I am trying to index and match (not sure whether this is correct to begin with) a column and row to find out what the intersect would be.
If the Month stated is not in the table then go up to the next month and select that score. e.g Month: 13 not there so go to Month: 24 - if the team then selected was Team 2 the result would be: 6
If the Month and Team matches select the score that intersects e.g Month 12 and Team 3 = Result: 2
I have attached a picture which shows desired results and the formula I have built up to now.
I have tried a lot of various formulas but have had no luck. I have also trawled the internet and cant find anything similar to my issue.
I hope I have supplied enough info for someone to figure my formula problem out.
Thanks
Bookmarks