Spreadsheet: 145750d1331729263-excel-2007-how-to-return-prices-from-multiple-lists-example
Sheet: Sheet1

 | 3000 | 2800 | 2600 | 2400 | 2200 | 2000 | 1800 | 1600 | 1400 | 1200 | 1000 | 800 | 600 | 0
3000 | 400 | 380 | 360 | 320 | 312.73 | 307.28 | 272.73 | 240 | 223.64 | 207.27 | 189.09 | 172.73 | 156.37 | 0
2800 | 387.28 | 369.09 | 349.09 | 309.09 | 303.64 | 296.37 | 265.46 | 232.73 | 218.18 | 201.82 | 185.46 | 169.09 | 154.55 | 0
2600 | 376.37 | 358.19 | 338.19 | 300 | 294.55 | 287.28 | 258.18 | 227.28 | 212.73 | 196.37 | 181.82 | 165.46 | 150.91 | 0
2400 | 363.64 | 347.28 | 329.09 | 290.91 | 285.46 | 278.18 | 250.91 | 220 | 205.46 | 192.73 | 178.18 | 163.64 | 149.09 | 0
2200 | 352.73 | 336.37 | 318.19 | 281.82 | 274.55 | 269.09 | 243.64 | 214.55 | 200 | 187.27 | 172.73 | 160 | 145.46 | 0
2000 | 341.82 | 325.46 | 309.09 | 272.73 | 265.46 | 260 | 236.37 | 207.27 | 194.55 | 181.82 | 169.09 | 156.37 | 143.64 | 0 | Group 1 Roller Prices
1800 | 329.09 | 312.73 | 298.18 | 261.82 | 256.37 | 250.91 | 229.09 | 201.82 | 189.09 | 176.37 | 163.64 | 152.73 | 140 | 0
1600 | 318.19 | 301.82 | 287.28 | 252.73 | 247.28 | 240 | 221.82 | 194.55 | 183.64 | 172.73 | 160 | 149.09 | 138.18 | 0
1400 | 305.46 | 290.91 | 278.18 | 243.64 | 238.18 | 230.91 | 214.55 | 189.09 | 178.18 | 167.27 | 156.37 | 145.46 | 134.55 | 0
1200 | 294.55 | 280 | 267.28 | 234.55 | 227.28 | 221.82 | 209.09 | 181.82 | 172.73 | 161.82 | 152.73 | 141.82 | 132.73 | 0
1000 | 281.82 | 269.09 | 256.37 | 225.46 | 218.18 | 212.73 | 201.82 | 176.37 | 167.27 | 158.18 | 149.09 | 140 | 129.09 | 0
800 | 270.91 | 258.18 | 247.28 | 214.55 | 209.09 | 203.64 | 194.55 | 169.09 | 161.82 | 152.73 | 143.64 | 136.37 | 127.27 | 0
600 | 258.18 | 247.28 | 236.37 | 205.46 | 200 | 192.73 | 187.27 | 163.64 | 154.55 | 147.27 | 140 | 132.73 | 125.46 | 0
 | 3000 | 2800 | 2600 | 2400 | 2200 | 2000 | 1800 | 1600 | 1400 | 1200 | 1000 | 800 | 600 | 0
3000 | 472.73 | 447.28 | 423.64 | 380 | 372.73 | 367.28 | 320 | 283.64 | 263.64 | 241.82 | 221.82 | 200 | 180 | 0
2800 | 456.37 | 432.73 | 409.1 | 367.28 | 360 | 354.55 | 310.91 | 274.55 | 256.37 | 236.37 | 216.37 | 196.37 | 176.37 | 0
2600 | 440 | 418.19 | 396.37 | 354.55 | 347.28 | 341.82 | 301.82 | 267.28 | 247.28 | 229.09 | 210.91 | 190.91 | 172.73 | 0
2400 | 425.46 | 403.64 | 383.64 | 341.82 | 334.55 | 329.09 | 292.73 | 258.18 | 240 | 221.82 | 205.46 | 187.27 | 169.09 | 0
2200 | 409.1 | 389.09 | 369.09 | 329.09 | 323.64 | 316.37 | 281.82 | 249.09 | 232.73 | 216.37 | 200 | 181.82 | 165.46 | 0
2000 | 394.55 | 374.55 | 356.37 | 316.37 | 310.91 | 303.64 | 272.73 | 241.82 | 225.46 | 209.09 | 194.55 | 178.18 | 161.82 | 0 | Group 2 Roller Prices
1800 | 378.19 | 360 | 341.82 | 303.64 | 298.18 | 290.91 | 263.64 | 232.73 | 218.18 | 203.64 | 189.09 | 172.73 | 158.18 | 0
1600 | 363.64 | 345.46 | 329.09 | 290.91 | 285.46 | 278.18 | 254.55 | 223.64 | 210.91 | 196.37 | 181.82 | 169.09 | 154.55 | 0
1400 | 347.28 | 330.91 | 314.55 | 278.18 | 272.73 | 265.46 | 243.64 | 214.55 | 201.82 | 189.09 | 176.37 | 163.64 | 150.91 | 0
1200 | 330.91 | 316.37 | 301.82 | 265.46 | 260 | 254.55 | 234.55 | 207.27 | 194.55 | 183.64 | 170.91 | 160 | 147.27 | 0
1000 | 316.37 | 301.82 | 287.28 | 252.73 | 247.28 | 241.82 | 225.46 | 198.18 | 187.27 | 176.37 | 165.46 | 154.55 | 145.46 | 0
800 | 300 | 287.28 | 274.55 | 241.82 | 234.55 | 229.09 | 216.37 | 189.09 | 180 | 170.91 | 160 | 150.91 | 141.82 | 0
600 | 285.46 | 272.73 | 260 | 229.09 | 221.82 | 216.37 | 205.46 | 181.82 | 172.73 | 163.64 | 154.55 | 145.46 | 138.18 | 0