Hi guys, I'm new to this forum, nice to meet you all
I actually created this account in the hope that somebody could help me
I am trying to make an index match formula that will look for values considering 4 total criterias (3 columns and 1 row)
I wanna get a result that matches "week" "month" "período" and "year", so January monday manhã of 2015 will give me the desired result however all i can get is error N/A meaning it didnt find a resut
I am using a formula with just 3 criterias (2 columns and 1 row) and still got no good results, I figured that should only go for 4 criterias after made 3 criterias work
So I tested in another sheet "Tabela Objetivos" with a small sample and it worked, I dont know why(only 3 criterias worked- Tried with 4 and didnt work)
I tried so much and got nothing
So i am asking for someone more experienced than me a little help
I am posting a link to access to the sheet from google drive (i read the posting section rules and found nothing that said I couldnt do it, so I hope i really can)
But if anything goes wrong, it is supossed to look like this: (just copied little part from the tables as matter of illustration: The main one has over 1500 rows and the other 250)
Formula Used:=INDEX($AE$4:$AJ$245,MATCH(B4&D4,$AB$4:$AB$245&$AC$4:$AC$245,0),MATCH(E4,$AE$3:$AJ$3,0)Used criterias Week Month and Year - and also used control shift enter
<tbody>
</tbody>
<tbody>
</tbody>
Thanks in advance!!
I actually created this account in the hope that somebody could help me
I am trying to make an index match formula that will look for values considering 4 total criterias (3 columns and 1 row)
I wanna get a result that matches "week" "month" "período" and "year", so January monday manhã of 2015 will give me the desired result however all i can get is error N/A meaning it didnt find a resut
I am using a formula with just 3 criterias (2 columns and 1 row) and still got no good results, I figured that should only go for 4 criterias after made 3 criterias work
So I tested in another sheet "Tabela Objetivos" with a small sample and it worked, I dont know why(only 3 criterias worked- Tried with 4 and didnt work)
I tried so much and got nothing
So i am asking for someone more experienced than me a little help
I am posting a link to access to the sheet from google drive (i read the posting section rules and found nothing that said I couldnt do it, so I hope i really can)
But if anything goes wrong, it is supossed to look like this: (just copied little part from the tables as matter of illustration: The main one has over 1500 rows and the other 250)
Formula Used:=INDEX($AE$4:$AJ$245,MATCH(B4&D4,$AB$4:$AB$245&$AC$4:$AC$245,0),MATCH(E4,$AE$3:$AJ$3,0)Used criterias Week Month and Year - and also used control shift enter
Week | Month | Year | Objetivo | Período | |
Sunday | November | 2015 | #N/A | Manhã | |
Monday | November | 2015 | #N/A | Manhã | |
Tuesday | November | 2015 | #N/A | Manhã | |
Wednesday | November | 2015 | #N/A | Manhã | |
Thursday | November | 2015 | #N/A | Manhã | |
Friday | November | 2015 | #N/A | Manhã | |
Saturday | November | 2015 | #N/A | Manhã | |
Sunday | November | 2015 | #N/A | Manhã | |
Monday | November | 2015 | #N/A | Manhã |
<tbody>
</tbody>
Week | Month | Período | 2015 | 2016 | 2017 | 2018 | 2019 |
Sunday | January | Manhã | a | b | a | a | a |
Monday | January | Manhã | b | a | a | a | a |
Tuesday | January | Manhã | d | a | a | a | a |
Wednesday | January | Manhã | d | a | a | a | a |
Thursday | January | Manhã | d | a | a | a | a |
Friday | January | Manhã | d | a | a | a | a |
Saturday | January | Manhã | d | a | a | a | a |
Sunday | February | Manhã | d | a | a | a | a |
Monday | February | Manhã | d | a | a | a | a |
<tbody>
</tbody>
Thanks in advance!!
HTML:
https://drive.google.com/file/d/0Bwb5OeJSR3hYcnlrUDV1VWlVU0k/view?usp=sharing