VLOOKUP formula for stock control

I put both tables in the EF 4015 workbook for simplicity.
A row 1 has been inserted over the 4012 table and populated using: =RIGHT(B2,LEN(B2)-FIND("C",B2)+1)
The formula for column E of the 4015 table is: =IF(AND(INDEX('EF 4012'!B$3:K$6,MATCH(B2,'EF 4012'!A$3:A$6,0),MATCH(A2,'EF 4012'!B$1:K$1,0))=0,D2="Yes"),"Available","Not Available")
Note: If the tables must be in different workbooks then 'EF 4012'! will need to be preceded by the path of the EF 4012 workbook.
Let us know if you have any questions.