Vlookup

[rztv8076]

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

[#2]

@rztv8076 

Does this do what you want?

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

[#3]

@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.

RZ

[#4]

@rztv8076 

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?