Text from two different cells to give value shown in certain cel [Solved]

Hello,,

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.

Person 1 Person 2

Week 1 - 5
Week 2 - 6
Week 3 - 7
Week 4 - 2
Week 5 - 1
Week 6 - 4

I would appriciate any help. Thank you in advance.

+0

Following your instructions I set an example:
https://www.sendspace.com/file/mrx4h7

Try this formula:

C1 --> =INDEX(\$C\$6:\$G\$57, MATCH(B1,\$B\$6:\$B\$57,0), MATCH(A1,\$C\$5:\$G\$5,0))

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Hi Mazzaropi,

Thank you a lot this helps a lot.
Only issue here is if I want to combine the numbers say if I wanted it to add Week 5 + Week 11 and Week 20 in the result. Like in a filter.
Say pick weeks 1-4 and it shows the total from those weeks.
Thank you a lot. This solved it all.
+0

This is not a problem.

You wanted to find a value according to 2 conditions.
I created a solution according to your request and there was nothing in it about adding selections.

To do something with filter does not need formula.
See Plan 2 of the worksheet.
https://www.sendspace.com/file/7i68s8

I hope it helps.