Spreadsheet: 680791d1591196295-help-with-if-and-book4
Sheet: Sheet1

supplier | part | [NAME] | price | per | [NAME] |  | true/false | [NAME] |  |  |  | Supplier | Part | PPU | [NAME] |  |  |  | Supplier | Part | PPU | [NAME]
JATON | SET12 |  | 34 | 1000 | 40345 |  | 0 |  |  |  |  | FAST | SET12 | 0.0192 | in 200's |  |  |  | FAST | SET12 | 0.0192 | in 200's
VAN-LI | SET12 | HSS50 | 27.35 | 1000 | 40560 |  | 0 |  |  |  |  | FAST | SET13 | 0.0198 | in 200's |  |  |  | FAST | SET13 | 0.0198 | in 200's
[NAME] | SET12 | HTSMET00800025Z | 20.5 | 1000 | 43983 |  | 0 |  |  |  |  | FAST | SET14 | 0.025 | in 200's |  |  |  | FAST | SET14 | 0.025 | in 200's
HIGH | SET12 |  | 25.2 | 1000 | 40345 |  | 0 |  |  |  |  | FAST | SET15 | 0.0296 | in 200's |  |  |  | FAST | SET15 | 0.0296 | in 200's
GALAXY | SET12 | &MHS08 025,081 | 20.1 | 1000 | 43509 |  | 0 | 12k MOQ |  |  |  | GALAXY | SET16 | 0.0424 | 1K MOQ |  |  |  | GALAXY | SET16 | 0.0424 | 1K MOQ
SAVILL | SET12 |  | 26.5 | 1000 | 40407 |  | 0 |  |  |  |  | FAST | SET17 | 0.0327 | in 200's |  |  |  | FAST | SET17 | 0.0327 | in 200's
MARTYN | SET12 | S08M08025Z-M8X25 BZP | 19.5 | 1000 | 40661 |  | 0
ENGINE | SET12 |  | 23.8 | 1000 | 40345 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | above works only in Excel 2016 and higher
AIC-I | SET12 |  | 19.1 | 1000 | 41151 |  | 0 | MOQ 40K. +6p BAGGED/LABELLED
WILLIA | SET12 | HTSM08025Z | 21 | 1000 | 41199 |  | 0
FASTPA | SET12 | XISS825 | 20 | 1000 | 42138 |  | 0
BAPP | SET12 |  | 15.5 | 1000 | 41954 |  | 0
BROWNS | SET12 |  | 22.6 | 1000 | 43251 |  | 0
FAST | SET12 | 093300800250008201 | 19.2 | 1000 | 43983 |  | 1 | in 200's
JATON | SET13 |  | 31.6 | 1000 | 40345 |  | 0
[NAME] | SET13 | HTSMET00800030Z | 25.5 | 1000 | 43983 |  | 0
HIGH | SET13 |  | 27.9 | 1000 | 40345 |  | 0
GALAXY | SET13 | &MHS08 030,081 | 22.9 | 1000 | 43521 |  | 0 | 12K MOQ
SAVILL | SET13 |  | 29.8 | 1000 | 40345 |  | 0
VAN-LI | SET13 | HSS105 | 28 | 1000 | 39114 |  | 0
MARTYN | SET13 | S08M08030Z | 21.8 | 1000 | 40661 |  | 0
ENGINE | SET13 |  | 24.6 | 1000 | 40345 |  | 0
AIC-I | SET13 |  | 21.9 | 1000 | 41151 |  | 0 | MOQ 40K. +6p BAGGED/LABELLED
WILLIA | SET13 | HTSM08030Z | 23 | 1000 | 41199 |  | 0
FASTPA | SET13 | XISS830 | 22.1 | 1000 | 42138 |  | 0
BAPP | SET13 |  | 17.2 | 1000 | 41954 |  | 0
BROWNS | SET13 |  | 23 | 1000 | 43251 |  | 0
FAST | SET13 | 093300800300008201 | 19.8 | 1000 | 43879 |  | 1 | in 200's
FOREM | SET14 | HSS51 | 6.07 | 200 |  |  | 0
JATON | SET14 |  | 31.1 | 1000 | 40513 |  | 0
VAN-LI | SET14 | HSS51 | 31.06 | 1000 | 39845 |  | 0
[NAME] | SET14 | HTSMET00800040Z | 30.8 | 1000 | 43983 |  | 0 | 22.10/K
HIGH | SET14 |  | 36.3 | 1000 | 40695 |  | 0
GALAXY | SET14 | &MHS08 040,081 | 25.1 | 1000 | 43348 |  | 0 | 12K MIN
SAVILL | SET14 |  | 33.3 | 1000 | 40360 |  | 0
MARTYN | SET14 | S08M08040Z | 35.7 | 1000 | 40485 |  | 0
ENGINE | SET14 |  | 28.2 | 1000 | 40311 |  | 0
AIC-I | SET14 |  | 24.45 | 1000 | 41151 |  | 0 | MOQ 40K. +6p BAGGED/LABELLED
WILLIA | SET14 |  | 26.3 | 1000 | 40725 |  | 0
FASTPA | SET14 | XISS840 | 26.6 | 1000 | 42138 |  | 0
BAPP | SET14 |  | 21 | 1000 | 41954 |  | 0
BROWNS | SET14 |  | 28.4 | 1000 | 43251 |  | 0
FAST | SET14 | 093300800400008201 | 25 | 1000 | 43983 |  | 1 | in 200's
FOREM | SET15 | HSS52 | 3.73 | 100 |  |  | 0
JATON | SET15 |  | 39.1 | 1000 | 40484 |  | 0
VAN-LI | SET15 | HSS52 | 49.5 | 1000 | 40179 |  | 0
[NAME] | SET15 | HTSMET00800050Z | 35.8 | 1000 | 43983 |  | 0
HIGH | SET15 |  | 44.4 | 1000 | 40779 |  | 0
GALAXY | SET15 | &MHS08 050,081 | 32 | 1000 | 43509 |  | 0 | 10K MOQ
SAVILL | SET15 |  | 39.6 | 1000 | 40445 |  | 0
MARTYN | SET15 | S08M08050Z | 37 | 1000 | 40780 |  | 0
ENGINE | SET15 |  | 33.8 | 1000 | 40518 |  | 0
AIC-I | SET15 |  | 33.01 | 1000 | 41151 |  | 0 | MOQ 40K. +6p BAGGED/LABELLED
WILLIA | SET15 |  | 30.7 | 1000 | 40725 |  | 0
FASTPA | SET15 | XISS850 | 28.9 | 1000 | 42138 |  | 0
BAPP | SET15 |  | 25.4 | 1000 | 41954 |  | 0
FAST | SET15 | 093300800500008201 | 29.6 | 1000 | 43971 |  | 1 | in 200's
JATON | SET16 |  | 52.7 | 1000 | 40325 |  | 0
VAN-LI | SET16 | HSS71 | 59.5 | 1000 | 40343 |  | 0
HIGH | SET16 |  | 60.2 | 1000 | 40338 |  | 0
FAST | SET16 | 093300800750008201 | 42.4 | 1000 | 43369 |  | 0 | in 200's
SAVILL | SET16 |  | 49.9 | 1000 | 40294 |  | 0
MARTYN | SET16 | S08M08075Z | 59.3 | 1000 | 40303 |  | 0
AIC-I | SET16 |  | 42.96 | 1000 | 41151 |  | 0 | MOQ 20K. +6p BAGGED/LABELLED
BAPP | SET16 |  | 34.2 | 1000 | 41954 |  | 0
GALAXY | SET16 | &MHS08 075,081 | 42.4 | 1000 | 43509 |  | 1 | 1K MOQ
[NAME] | SET16 | HTSMET00800075Z | 48.9 | 1000 | 43983
FOREM | SET17 | HSS53 | 4.05 | 100 |  |  | 0
JATON | SET17 |  | 44 | 1000 | 40704 |  | 0
VAN-LI | SET17 | HSS53 | 37.2 | 1000 | 39114 |  | 0
[NAME] | SET17 | HTSMET01000025Z | 31.4 | 1000 | 43983 |  | 0
HIGH | SET17 | HTSMETO1000025Y | 41.8 | 1000 | 40704 |  | 0
GALAXY | SET17 | &MHS10 025,081 | 37 | 1000 | 43880 |  | 0 | 10K MOQ
SAVILL | SET17 |  | 55 | 1000 | 40407 |  | 0
MARTYN | SET17 | S08M10025Z | 36.7 | 1000 | 40661 |  | 0
ENGINE | SET17 |  | 32.4 | 1000 | 40345 |  | 0
AIC-I | SET17 |  | 33.2 | 1000 | 41151 |  | 0 | MOQ 20K. +6p BAGGED/LABELLED
BAPP | SET17 |  | 29.9 | 1000 | 41954 |  | 0
BROWNS | SET17 |  | 35.6 | 1000 | 43251 |  | 0
FAST | SET17 | 093301000250008201 | 32.7 | 1000 | 43971 |  | 1 | in 200's