New Contributor

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.

OrdernumberphotonamesurnameclassposAt Bat
12222.pngGriffin TurnerSenior 2
233.pngRyan KramerJunior 3
355.pngSam ColemanJunior 4
41616.pngGrant FackelJunior 5
544.pngTrip HooksJunior 6
699.pngLiam BannisterJunior 7
766.pngWill WallaceJunior 8
82121.pngLeo HohmanJunior 9
977.pngJack KaleJunior 10
3 Replies


Does this do what you want?


=VLOOKUP(A18,'Baseball Score Feed'!A12:H20,8,FALSE)

@Hans Vogelaar 


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.



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?