Hi all,
I'm a newbie to this forum but have browsed it many a times looking for answers. I think of myself as quite good at doing spreadsheets as secretly i absolutely love doing them, get a real buzz from them, but i've come a cropper with my latest one. I'm doing a football spreadsheet & i've setup a sheet with all the results on so far & 2 columns next to the results saying if its a home win, draw or away win. What i'm stuck on is my next sheet where i've put all the teams down the left hand side & their games along the top, in between i want it to say for example...
1 2 3 4 5 6 7
AFC Bournemouth L L L L W D L
Arsenal
Brighton
I want to know what the formula is so that it'll look up AFC Bournemouth's first game, 2nd game & so on so instead of typing it in manually the spreadsheet does it for me.
Regards
Steve
Bookmarks