Report

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
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.

Helpful
+0
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:
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
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.
Reply
fgadim- Jan 2, 2017 at 11:25 AM
Thank you a lot. This solved it all.
Reply
Leave a comment
Helpful
+0
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.
https://www.sendspace.com/file/7i68s8

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!