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

fgadmin - Jan 1, 2017 at 08:30 PM - Latest reply:  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.

See more 

4 replies

Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Jan 2, 2017 at 07:02 AM
0
Helpful
2
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.
Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Jan 2, 2017 at 10:02 AM
0
Helpful
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.