I've got a sheet with a bunch of names (first last in one cell) sorted in alphabetical order. It's data for NFL players.
The table has several columns of values.
On another section of the sheet, I have a place to type in some of the player names, and then VLOOKUP functions to retrieve a value from the table, so you can compare specific player statistics.
Problem is, VLOOKUP is looking through the table and returning the value in the cell 1 spot ABOVE the reference it should be.
So, if I had:
Dave Jones, and asked Vlookup("Dave Jones", Table, Column 2)
And the table is:
Adam Smith 3
Dave Jones 2
Mark Wilson 5
It would be returning value 3.
The table is more complex than this, but it's weird it would return the value above. Any suggestions? I can post a screen shot if it will help.
Bookmarks