Advanced Lookup Excel required

i'm in need of some advanced lookup formula with Max, Min, If, and sum.

I am quite new to it, and i've been trying some different formula's but i can't seem to get it remotely close.

Info:

Sheet1 (data): Column one(A): name Column two (B): Type Column three (D1:AO): Data/numbers

Row 1: A1=Name, B1= Type, D1:AO1=name of the different data

Sheet2 (output):

B5: Primary Critera, Selecting from a dropdownlist of Sheet1.Row(D1:AO1)

B7: Secondary Critera, Selecting from a dropdownlist of Sheet1.Row(D1:AO1)

B8: Tertiary Critera, Selecting from a dropdownlist of Sheet1.Row(D1:AO1)

B9: Quaternary Critera, Selecting from a dropdownlist of Sheet1.Row(D1:AO1)

B10: Quinary Critera, Selecting from a dropdownlist of Sheet1.Row(D1:AO1)

What i want:

Step 1:

I want it to find the row in sheet1(D1:AO1) that matches Sheet2(B5), and find the Maximum value in that column and paste the name Sheet1(Column one).

Step 2 (Maximum criteria):

There are five different types Sheet1(Column two). I want it to find Step 1 for each of them (so 5 Maximum value, pasting the name in 5 different cells).

Step 3 (Minimum criteria):

Sheet2(B7:B10) are 4 minimum criterias(such as =<10), which also needs to be taken into consideration (unless its "None"). Like step one these 4 cells are dropdown lists

Step 4 (Total):

Sum up the values of each of the criterias in different cells

Example:

Type 1-5: Books, Cd's, DVD's, Clothes, Shoes - 100 different of each Type

B5: Primary Critera: Selling Price

B7: Secondary Critera: Market value =< 10

Then i want it to find the highest selling price (Primary Criteria), with a minimum market value of 10, for each Type 1-5. Also, pasting the sum of selling price (5 prices in total), and pasting the sum of market value (5 values in total).

basically this is how i tried to start step 1:

If(B5="None";"";MAX(VLOOKUP(B5='Sheet1!'!D1:AO1 But, i got stock since it's lookup in sheet1.cells(D1:AO1), and pasting is column one.

Hope this makes sense, and you guys can help me.

Also, it would even be a great help if you could just solve one of the steps.

Thanks in advance!

Best regards

Koefoed