Forum Discussion
rztv8076
Mar 12, 2023Copper Contributor
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'!A...
HansVogelaar
Mar 12, 2023MVP
- rztv8076Mar 12, 2023Copper Contributor
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
- HansVogelaarMar 12, 2023MVP
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?