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

Report
-
 fgadim -
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 replies

Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
fgadim, Good morning.

Please next time show us your example file.
This helps us to help you.

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.
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
fgadmin, Good afternoon.

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.