Hi,
I downloaded a program for completing a football results program. I altered the original to increase the number of teams and sorted out the cliches in the original program. This now works effectively with no problems. The only niggle I have is that all the results have to be entered via the Fixture Grid Sheet. What I am aiming to do is enter via another sheet, Full Fixture List.
To give a basic run down to enter the result is as follows. Enter result of 1st match in F2 (Home Team column E) and H2 (Away Team column I) on Full Fixture List. This result, after finding relevant cell to column E and I on Full Fixture List, is entered on the Fixture Grid Sheet from cell J2 (data format for the rest of the program) . The vertical cells are for Home teams and horizontal for away teams. Also I am trying to do and if / or in that if there is no result the the fixture date is displayed, stored at C2 on Full Fixture List. This of course is then repeated for all other matches through the season.
I have tried using VLOOKUP and HLOOKUP, also IF but all I seem to do is make a complete unusable mass of formula with no direction at all. Now I am, after several blundering attempts, calling out for help.
Attached are the relevant sheets that are required for the formula I am looking for help to complete.
Bookmarks