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

Ask a question fgadmin - Last answered on Jan 2, 2017 at 11:25 AM by fgadim

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 
plus moins
fgadim, Good morning.

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

Following your instructions I set an example:

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
fgadmin- Jan 2, 2017 at 08:05 AM
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.
fgadim- Jan 2, 2017 at 11:25 AM
Thank you a lot. This solved it all.
Leave a comment
plus moins
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.

I hope it helps.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!