Column based on selection

[#1]

I have few data as per enclosed file.

Worksheets

Supplier showing all supplier I have

A showing data for supplier A

B showing data for supplier B

C showing data for supplier C

Final showing final table I need

If I will select Supplier B from supplier table (worksheet supplier), my final table should be as below

i.e. no price will appear for all parts in Supplier B column so that they will not be calculated while getting Min price.

Column 6 will automatically show Data for Supplier B (as selected above and ignored column in getting Min price) and % difference will be calculated in column 7 (% Diff)

i.e. (Min-Supplier B)/Supplier B

Part	Supplier A	Supplier B	Supplier C	Min	Supplier B	% Diff
X	10		20	10	40	-75.00%
Y	20			20
Z	30		15	15	50	-70.00%

Regards,

Manish Kachhia

[#2]

Can anyone please reply?

[#3]

Thanks to all who has read this discussion.

I tried and solved myself.