Need Solution With Fantasy Baseball Spreadsheet

This should be a batting practice fastball right down the middle for any Excel guru.

What I am looking to have done is simple in concept but has been giving me fits. Let me just use one example of what I need done.

Let's say in Sheet 1 and in cell B4 I have the player name "Justin Upton". In cell C4 of Sheet 1 I want to pull data from Sheet 2 referring to the text ("Justin Upton") in cell B4. When it finds the cell that reads "Justin Upton" in Sheet 2, I want to then pull the text from the cell 3 below and 3 to the right of it.

So if "Justin Upton" was located in cell A1 of Sheet 2, then I want cell C4 of Sheet 1 to pull the text from cell D4 of Sheet 2. Make sense?

I think this involves the Index() and Offset() commands, but I still a casual Excel user and can't put it together. Hopefully this problem is clear and can easily be solved.

Sheet 1.jpg
Sheet 2.jpg

I want to pull the data from the marked cell on the bottom page (Sheet 2) into the marked cell on the top page (Sheet 1).

Basically the formula in cell C819 in Sheet 1 needs to refer to the player name in cell B819 and then locate that same name on Sheet 2.At that point it needs to find the location of the cell with the relevant statistic. In this case, the location would be down 3 and over to the right 3, in cell D665 of Sheet 2.

Hope this clears things up.

Gotcha. Here is a brief workbook sample I created that will make it easier to look over and edit, in case anyone wants to step up to the plate and solve this.

Anyone? Would appreciate some help here.

Thanks for taking the time to help me with this! I'll let you know if I run into any other problems.