I'm trying to solve a problem I have with a list of values and text. I have a schedule of with names
I will get two values in different cell. Say A1 I get the Person 1 and B1 I get Week 1 - In C1 I want the value that is from Person 1 and Week 1.
The data will be listed in the same sheet. So person 1 would be in C5. While Weeks would range from B6:B58. But Values for Person 1 would be in C6:58
And if I pick Person 2 it would be D5 and values in D6:58, and so on. I have this for several persons.
So in Basic if I put in Person 1 in A1 (Data from C5) and Week 5 in B1 (Data from B10) I would need it to show value from C10.