I have 2 sheets of data in a workbook as below:
Sheet source:
<tbody>
</tbody>
Sheet Destination:
<tbody>
</tbody>
'Sheet Destination' is formatted differently, and I need to pull values from 'Sheet source' though its similar.
I used the formula: =(INDEX(Destination!$C$2:$C$89,MATCH(Source!$A27:$A36&$B27:$B36,Destination!$A$2:$A$89&Destination!$B$2:$B$89,0)))
But its returning me Error value: #VALUE !
Please help!
Sheet source:
Category1 | Category2 | July | August |
sports | apparel | 9 | 11 |
sports | accessories | 6 | 14 |
sports | other | 23 | 15 |
casual | apparel | 15 | 19 |
casual | accessories | 20 | 17 |
<tbody>
</tbody>
Sheet Destination:
Category1 | Category2 | July | August |
sports | apparel | FORMULA | |
sports | accessories | ||
sports | other | ||
casual | apparel | ||
casual | accessories |
<tbody>
</tbody>
'Sheet Destination' is formatted differently, and I need to pull values from 'Sheet source' though its similar.
I used the formula: =(INDEX(Destination!$C$2:$C$89,MATCH(Source!$A27:$A36&$B27:$B36,Destination!$A$2:$A$89&Destination!$B$2:$B$89,0)))
But its returning me Error value: #VALUE !
Please help!