Forum Discussion
Vlookup
How to best lookup data that first column is not in numeric order? I would like to return the "At Bat" for player number in roster stats. ANY HELP APPRECIATED.
=VLOOKUP(A18,'Baseball Score Feed'!A12:H20,8) returns "At Bat" for last row in array.
| Order | number | photo | name | surname | class | pos | At Bat |
| 1 | 22 | 22.png | Griffin | Turner | Senior | 2 | |
| 2 | 3 | 3.png | Ryan | Kramer | Junior | 3 | |
| 3 | 5 | 5.png | Sam | Coleman | Junior | 4 | |
| 4 | 16 | 16.png | Grant | Fackel | Junior | 5 | |
| 5 | 4 | 4.png | Trip | Hooks | Junior | 6 | |
| 6 | 9 | 9.png | Liam | Bannister | Junior | 7 | |
| 7 | 6 | 6.png | Will | Wallace | Junior | 8 | |
| 8 | 21 | 21.png | Leo | Hohman | Junior | 9 | |
| 9 | 7 | 7.png | Jack | Kale | Junior | 10 |
No - returns "N/A"
Problem is lookup cell comes from range not sequential. Tried INDEX, MATCH functions which don't work either.
Can't go to Cell directly because batting order changes.
I can generally figure out but not this time.
Appreciate the continued help.
RZ
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
