Matrix Compare Report

Ok, let me explain.. In the sheet last tab (Local stockfile) has all the items (SKUs) they sell and cost and Retail prices. Column A and B shows their departments and fine lines respectively. 3 rd tab (Trade01-06 Matrix extract) tab is the download of pricing discount structure. If you filter column A you can see 6 types of Matrix IDs. For example of if you just filter by column A by TRADE01.  First from row 4 to 21 shows department discount structure  From row 22 to row 50 shows Fineline discount structure  Row 2 and 3 applies for all the items (skus). 2 nd tab (SKU check) is the ideal report im after. Basically when you enter Item (SKU) numer in cell A3 it shows all the discount structures, Column C to column P returns corresponding data from tab 2 (TRADE 01-06 Matrix extract). Sorry order in my sketch report tab (SKU Check) is not the same,,but im basically after the same information. Ignore columns from Q to Y in SKU check tab. This is to determine calculate best price depend on the price basis, I can design this part. If you can help me out to design what im after that would be great. Let me know if you have any questiions. --- cell I4 (best price) & J4 (GP%) is the best sell rate (column X) depending how many combination of matrices that item (SKu) has..Column Q to W you dont need to worry,