i have a vlookup function that is supposed to give me some data from another worksheet. the worksheet contains soccer data, specifically about the european cups of the past 3 years (9-10, 10-11,11-12, 12-13 isnt in there because its not finished yet, allthough dortmund will win ;))
anyway, the data is spread into two worksheets. One contains the total number of points a team has managed to achieve during their matches in all european cup games, as well as some additional data, such as points achieved during qualifying matches, etc. the sheet, in this case, is called '11-12 ranking'.
the other sheet, called '11-12 games' contains ALL european cup matches played in that season, as well as the results of these matches, for ALL teams, not just for one!
so the data looks like this:
A B C team A pointsTeamA qualifyingPointsTeamA team B pointsTeamB qualifyingPointsTeamB team C pointsTeamC qualifyingPointsTeamC . . . . . . . . . . . .
where pointsTeamA, etc, and qualifyingPointsTeamA, etc. are numbers, and team A, team B, etc. are the names of the Teams, e.g. Real Madrid, etc.
the interesting parts of the other sheet, '11-12 games', contain a list of UNIQUE names of ALL teams which qualified and played in european cups in that season. In the column to the right of these names, I would like to look up the amount of points scored by that team in that season, which are stored, as i said, in the other sheet, '11-12 ranking'. So '11-12-games looks like this.
A B C uniqueTeamName A =VLOOKUP(A1,'11-12 ranking'!$A$3:$I$292,2) uniqueTeamName B =VLOOKUP(A2,'11-12 ranking'!$A$3:$I$292,2) uniqueTeamName C =VLOOKUP(A3,'11-12 ranking'!$A$3:$I$292,2) . . . . . . . .
However, what I actually get In column B of above spreadsheet, is a value matching another row in the lookup spreadsheet, not the value matching the row I want it to match?! I dont know why at the moment. I have checked with a simple if statement that the values I would expect to match across the sheets (e.g. uniqueTeamName A = TeamName A) do match, for example, for the case that would both of these values are 'Madrid', 'Barcelona', or whatever. So I don't know, at the moment, why it isn't looking up these values correctly. Is anyone able to help on this? :) Thanks a lot in advance!! Cheers, and if anyone is interested in the results I am getting from this, I can post them later! Thanks,