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.

Zone	Pallet Type	Company A	Company B
1	Full Next Day
Shipping Company A
Zone	Full Next Day	Half Next Day	Quarter Next Day	Full Economy	Half Economy
1	£ 27.30	£ 23.10	£ 21.00	£ 24.15	£ 21.00
2	£ 35.70	£ 31.50	£ 27.30	£ 31.50	£ 27.30
3	£ 39.90	£ 35.70	£ 31.50	£ 33.60	£ 31.50
4	£ 45.15	£ 39.90	£ 35.70	£ 38.85	£ 34.65
5	£ 52.50	£ 40.95	£ 36.75	£ 42.00	£ 35.70
6	£ 52.50	£ 42.00	£ 37.80	£ 47.25	£ 36.75
7	N/A	N/A	N/A	£ 84.00	£ 73.50
Shipping Company B
Zone	Full Next Day	Half Next Day	Quarter Next Day	Full Economy	Half Economy
1	£ 26.00	£ 23.10	£ 22.00	£ 25.00	£ 20.00
2	£ 35.00	£ 32.00	£ 28.00	£ 30.00	£ 29.00
3	£ 39.90	£ 33.00	£ 29.00	£ 33.00	£ 28.00
4	£ 43.00	£ 39.00	£ 32.00	£ 39.00	£ 31.00
5	£ 57.00	£ 42.00	£ 37.00	£ 41.00	£ 32.00
6	£ 55.00	£ 43.00	£ 38.00	£ 46.00	£ 37.00
7	N/A	N/A	N/A	£ 88.00	£ 74.00

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Help!

regards