using index with multiple conditions

[trekker1218]

Hello all,
I am trying to match 2 cells and post result of another cell. here is where I am now. I have 100 attribute labels and attribute values in one workbook. Need to extract the matching Item number I lookup and then find and match all attribute labels and values that are relevant to matching items#.

I need to enter a item# in a cell and then get results from 2 other workbooks.

=INDEX('[Item_Builder_Master.xlsx]ALL-Prods'!$A:$FB,MATCH(L2,'[Item_Builder_Master.xlsx]ALL-Prods'!$A:$A,0)*MATCH('Step 1 - Product Type'!C2,'[Item_Builder_Master.xlsx]ALL-Prods'!$BA$3:$FB$3,0),58)

i need to match an Item number in (###) in 'Item_Builder_Master.xlsx' & match an attribute (###) in the ROW of the 1st match then post result of matching attribute result in the column next to the matching attribute label.
The problem I am having is the attributes labels may not always be in the same COL. or have the same attribute label name.