Sorry! need help again. Compare 2 tables using data validation/dropdown lists

[sibley14]

Hi, sorry I've been banging my head against my desk and screen as i just can't seem to get my head around this.

Basically i'm trying to create a sheet whereby we can compare carriage costs between two companies using drop down lists.

So if we select the Zone and Pallet Type (Which are drop down lists) then it will show data from each company A and B which are listed in tables

Here's what i have so far. Only Zone and Pallet Type will be drop down lists. and i need Company A and Company B to display the results of each so that they can be compared.

[TABLE="width: 796"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Zone[/TD]
[TD]Pallet Type[/TD]
[TD]Company A[/TD]
[TD]Company B[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Full Next Day[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 6"]Shipping Company A[/TD]
[/TR]
[TR]
[TD]Zone[/TD]
[TD]Full Next Day[/TD]
[TD]Half Next Day[/TD]
[TD]Quarter Next Day[/TD]
[TD]Full Economy[/TD]
[TD]Half Economy[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] £ 27.30[/TD]
[TD] £ 23.10[/TD]
[TD] £ 21.00[/TD]
[TD] £ 24.15[/TD]
[TD] £ 21.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] £ 35.70[/TD]
[TD] £ 31.50[/TD]
[TD] £ 27.30[/TD]
[TD] £ 31.50[/TD]
[TD] £ 27.30[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] £ 39.90[/TD]
[TD] £ 35.70[/TD]
[TD] £ 31.50[/TD]
[TD] £ 33.60[/TD]
[TD] £ 31.50[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD] £ 45.15[/TD]
[TD] £ 39.90[/TD]
[TD] £ 35.70[/TD]
[TD] £ 38.85[/TD]
[TD] £ 34.65[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD] £ 52.50[/TD]
[TD] £ 40.95[/TD]
[TD] £ 36.75[/TD]
[TD] £ 42.00[/TD]
[TD] £ 35.70[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD] £ 52.50[/TD]
[TD] £ 42.00[/TD]
[TD] £ 37.80[/TD]
[TD] £ 47.25[/TD]
[TD] £ 36.75[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD] N/A [/TD]
[TD] N/A [/TD]
[TD] N/A [/TD]
[TD] £ 84.00[/TD]
[TD] £ 73.50[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shipping Company B[/TD]
[/TR]
[TR]
[TD]Zone[/TD]
[TD]Full Next Day[/TD]
[TD]Half Next Day[/TD]
[TD]Quarter Next Day[/TD]
[TD]Full Economy[/TD]
[TD]Half Economy[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] £ 26.00[/TD]
[TD] £ 23.10[/TD]
[TD] £ 22.00[/TD]
[TD] £ 25.00[/TD]
[TD] £ 20.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] £ 35.00[/TD]
[TD] £ 32.00[/TD]
[TD] £ 28.00[/TD]
[TD] £ 30.00[/TD]
[TD] £ 29.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] £ 39.90[/TD]
[TD] £ 33.00[/TD]
[TD] £ 29.00[/TD]
[TD] £ 33.00[/TD]
[TD] £ 28.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD] £ 43.00[/TD]
[TD] £ 39.00[/TD]
[TD] £ 32.00[/TD]
[TD] £ 39.00[/TD]
[TD] £ 31.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD] £ 57.00[/TD]
[TD] £ 42.00[/TD]
[TD] £ 37.00[/TD]
[TD] £ 41.00[/TD]
[TD] £ 32.00[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD] £ 55.00[/TD]
[TD] £ 43.00[/TD]
[TD] £ 38.00[/TD]
[TD] £ 46.00[/TD]
[TD] £ 37.00[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD] N/A [/TD]
[TD] N/A [/TD]
[TD] N/A [/TD]
[TD] £ 88.00[/TD]
[TD] £ 74.00[/TD]
[/TR]
</tbody>[/TABLE]

Help!

regards