Lookup 2 values to return 1 value

Hi there, please can you help me transfer data from 1 spreadsheet to another (I have attached a file which has 2 sheets).

I am trying to populate columns G to L (sheet B) with data from column H (sheet A) - the lookup is between 'Material' & '7410','7090','7680','7060','8630','7580' on sheet B & material & plant on sheet A.

I have tried H&VLOOKUP & INDEX/MATCH but I keep returning a #N/A..I am new to these functions and would appreciate your help.

Many Thanks
Glen