index match 2 workbooks

[genisys]

Dear all Sifus,

im trying to index match across 2 workbooks and return price value based on the product's uom, but it seems not working.. i have upload to dropbox, appreciate if someone can help rectify my formula

here is the link https://www.dropbox.com/s/a7qu91fhloq6cz8/index match price.zip?dl=0

Thanks.

 

[cunningAce]

=INDEX('[raw data.xlsx]Sheet1'!$C$7:$D$9,MATCH(D2,'[raw data.xlsx]Sheet1'!$C$7:$C$9,0),2)