Find specific value in Row, Return Text from Adjacent Cell

Hi, welcome to the forum

Are you looking for 10 in a row of cells?
=index(1:1,match(10,1:1,0-1)

or do you want to search down a column, and find the row that has 10 in it?
=index(A:A,match(10,B:B,0))

If this does not help you, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Thank you for the response! I've actually been around the forum for a couple of years now, but I've never had to post as I've always been able to get an answer by searching threads - this is the first time I wasn't able to find the answer on my own. I love this forum!

Attached is an example of the data set I'm working with. Each row is the data from a specific baseball game. The player ID, player name, and position played for each of the players on the Away team are listed in columns DB:EB. I want to find who played a specific position in each game. In this case, I want to know who played position "10" (designated hitter) on the Away team.

To do that, I need Excel to search for the number 10 within that set of data on row 2 between columns DB and EB, and then return the name of the player listed immediately to the left of that number 10. In the attached example, the formula should return the name "Harmon Killebrew."

I hope this makes sense.

Thank you!

EXAMPLE 1.xlsx

yOU ALMOST HAD IT...
=INDEX(DB2:EB2,MATCH(10,DB2:EB2,0)-1)

Note that you have more that 1 10 in row 2, that will ONLY pick up the 1st 1

Awesome. What the -1 does, is move back 1 cell from what the MATCH finds, so it has to be outside the MATCH