# Text from two different cells to give value shown in certain cel

Solved/Closed
fgadmin - Jan 1, 2017 at 08:30 PM
fgadim - Jan 2, 2017 at 11:25 AM
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.

## 2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jan 2, 2017 at 07:02 AM

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.
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jan 2, 2017 at 10:02 AM