excel2007uk
New Member
- Joined
- Jul 13, 2018
- Messages
- 13
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
<tbody>
</tbody>
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>