Comparing 2 tables of supplier prices to find lowest value

[excel2007uk]

Hi,

Im really stuck on this, can anyone help?

I'm trying to compare two tables of prices from suppliers to find the lowest for each item. Table 1 has around 300 prices in with the product spec on the left with qty on the top. Table 2 has slightly less as this supplier doesn't sell some of the items. I have left those blank. I need to find the lowest number price for each cell in this table & preferable know which supplier it has come from.

The best way of doing this I thought was have 3 tables: "supplier 1" - "supplier 2" - "Cheapest". Then from this "cheapest" table, I would have to pull data from this into another sheet called "0201 BC" using
=INDEX('Board Prices'!$C$3:$H$100,MATCH('0201 BC'!$B$14&'0201 BC'!$B$15,'Board Prices'!$A$3:$A$100&'Board Prices'!$B$3:$B$100,0),MATCH($C$28,'Board Prices'!$C$2:H$2,1)).
Is there any way I could see which supplier it has come from the sheet 0201 BC?

Any help is very much appreciated! Sorry I can't seem to attach a photo

			1200	460
Grade	Flute	200	500	1000	3000	6000	10000							Grade	Flute	200	500	1000	3000	6000	10000
125T125T	B	951	834	825	816	807	798							125T125T	B	1170	978	936	909	894	882
125L125T	B	981	864	855	846	837	828							125L125T	B	1218	1023	987	963	936	927
125K125T	B	1008	888	879	870	861	852							125K125T	B	993	963	909	909	909	909
125K125K	B	0	1068	1038	1038	1038	1038							125K125K	B	0	0	0	0	0	0
150T150T	B	0	858	843	831	819	807							150T150T	B	1260	1053	1014	990	969	948
150L150T	B	975	888	873	861	849	837							150L150T	B	1269	1077	1038	1014	996	978
150K150T	B	1017	927	912	900	888	876							150K150T	B	1068	990	990	990	990	990
150K150K	B	0	1107	1077	1077	1077	1077							150K150K	B	0	1269	1218	1191	1158	1140
200T200T	B	0	1125	990	978	966	954							200T200T	B	0	0	0	0	0	0
200L200T	B	1245	1155	1020	1008	996	984							200L200T	B	1443	1260	1206	1173	1155	1125
200K200T	B	1275	1185	1050	1038	1026	1014							200K200T	B	1506	1317	1260	1227	1209	1185
200K200K	B	0	1425	1230	1218	1206	1194							200K200K	B	0	1425	1371	1338	1311	1278
125T125T	R	0	822	813	804	795	786							125T125T	R	0	0	0	0	0	0
125L125T	R	0	852	843	834	825	816							125L125T	R	0	0	0	0	0	0
125K125T	R	0	876	867	858	849	843							125K125T	R	0	0	0	0	0	0
150L150T	R	0	876	861	849	837	825							150L150T	R	0	0	0	0	0	0
150K150T	R	0	915	897	888	876	864							150K150T	R	0	0	0	0	0	0
200L200T	R	0	1143	1008	996	984	972							200L200T	R	0	0	0	0	0	0
200K200T	R	0	1173	1038	1026	1014	1002							200K200T	R	0	0	0	0	0	0
125L125T	C	1044	924	915	906	900	891							125L125T	C	0	0	0	0	0	0
125K125T	C	1074	954	945	936	930	921							125K125T	C	0	1152	1113	1086	1068	1053
150T150T	C	0	984	975	966	960	951							150T150T	C	0	0	0	0	0	0
150L150T	C	1134	1014	1005	996	990	981							150L150T	C	0	0	0	0	0	0
150K150T	C	1164	1044	1035	1026	1020	1011							150K150T	C	1362	1239	1104	1104	1104	1104
150K150K	C	0	1224	1185	1176	1170	1161							150K150K	C	0	0	0	0	0	0
200T200T	C	0	1260	1230	1215	1215	1215							200T200T	C	0	0	0	0	0	0
200L200T	C	1350	1290	1260	1245	1236	1227							200L200T	C	0	0	0	0	0	0
200K200T	C	1380	1320	1290	1275	1275	1275							200K200T	C	1584	1392	1338	1305	1281	1260
200K200K	C	0	1500	1470	1455	1455	1455							200K200K	C	0	0	0	0	0	0
300K300T	C	1620	1560	1530	1515	1515	1515							300K300T	C	0	1821	1749	1701	1677	1644
300K300K	C	0	1860	1830	1830	1830	1830							300K300K	C	0	0	0	0	0	0
125T125T	BC	1320	1290	1245	1245	1245	1245							125T125T	BC	1701	1506	1473	1440	1431	1410

<tbody>
</tbody>