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