VLOOKUP with multiple values - creating a drop down list showing bigger value first

Hi,

Good Day.

Please find below, my doubt & attachment

Sheet 1


Part No. Description UOM Norms Supplier Price
P1 Housing EA 1
P2 End Plate LB 2
P3 Bearing EA 2
P4 Cover EA 2
P5 Washer EA 4

P1 to be searched in sheet2
P1 has many suppliers & different suppliers (sheet2)
F2 to be filled with P1's maximum price
E2 to be filled with corresponding to F2


Sheet 2

Part No. Description Supplier Price
P2 End Plate Supp2 1.3
P1 Housing Supp2 1.4
P2 End Plate Supp6 1.6
P1 Housing Supp3 2
P2 End Plate Supp1 2.5
P4 Cover Supp5 2.6
P1 Housing Supp4 2.78
P3 Bearing Supp2 3.2
P5 Washer Supp1 3.5
P2 End Plate Supp3 3.7
P3 Bearing Supp5 3.8
P1 Housing Supp6 4.2
P2 End Plate Supp4 4.23
P3 Bearing Supp3 5
P3 Bearing Supp4 6.22
P4 Cover Supp4 6.22
P3 Bearing Supp1 6.8
P2 End Plate Supp5 7.4
P1 Housing Supp5 8.1


Please help me to solve

Thanks & Regards,
Saravanan R
Mobile: +91 99400 16098
Skype: ram.saravana
Mail: [email protected]