VLOOKUP/INDEX grab same row?

[nobodyukno]

Ok here's a picture of where I need to pull information from:

Attachment 247165

So that information is pulled from the internet so it constantly changes.

Is there anyway to lookup the player names on the left and somehow pull the information from above?



For example:

Lookup player named "Martin Prado"

Somehow pull this information: Shaun Marcum (nym) - throws R vs. ari - 7:10 PM ET - Citi Field

But also pull that same information if I lookup player named "Miguel Montero"

[nobodyukno]

Anyone have any idea?