Hi,
How to index match with date and month ranges. I am looking for two different output based on the following data.
1. Date wise
2.Month wise
I apply the following formula in I3==IF(MATCH($G$3,$A$3:$A$1000,0),INDEX(DATA!$C$3:$E$1000,MATCH($H3,DATA!$B$3:$B$1000,0),MATCH(I$2,DATA!
$C$2:$E$2,0))) but I got wrong output.
Data Range:A2:A11 and Output Range:G2:K10
https://www.dropbox.com/s/cfeq8vfcr9pvaq6/INMA.PNG?dl=0
Any help much appreciated.
<colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
How to index match with date and month ranges. I am looking for two different output based on the following data.
1. Date wise
2.Month wise
I apply the following formula in I3==IF(MATCH($G$3,$A$3:$A$1000,0),INDEX(DATA!$C$3:$E$1000,MATCH($H3,DATA!$B$3:$B$1000,0),MATCH(I$2,DATA!
$C$2:$E$2,0))) but I got wrong output.
Data Range:A2:A11 and Output Range:G2:K10
https://www.dropbox.com/s/cfeq8vfcr9pvaq6/INMA.PNG?dl=0
Any help much appreciated.
DATA | OUTPUT | ||||||||||
DATE | COUNTRY | APPLE | BANANA | BILBERRY | DATE | COUNTRY | APPLE | BANANA | BILBERRY | DATE WISE | |
01/01/2018 | UK | 1 | 58 | 5 | 02/01/2018 | UK | 1 | 58 | 5 | ||
US | 5 | 48 | 24 | US | 5 | 48 | 24 | ||||
EU | 78 | 44 | 446 | EU | 78 | 44 | 446 | ||||
02/01/2018 | UK | 48 | 48 | 48 | |||||||
US | 21 | 21 | 12 | DATE | COUNTRY | APPLE | BANANA | BILBERRY | MONTHWISE | ||
EU | 11 | 11 | 1515 | Jan-18 | UK | 50 | 107 | 54 | |||
03/01/2018 | UK | 1 | 1 | 1 | US | 27 | 70 | 37 | |||
US | 1 | 1 | 1 | EU | 90 | 56 | 1962 | ||||
EU | 1 | 1 | 1 |
<colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>