Spreadsheet: 840157d1692509012-formula-isnumber-search-gazelle-correct-
Sheet: CERVELO

GAZELLE
model | # sold in year | pct sales for models
CERVELO CALEDONIA | 18 | 0.3333333333333333
CERVELO P | 16 | 0.2962962962962963
CERVELO ASPERO | 11 | 0.2037037037037037
CERVELO R5 | 4 | 0.07407407407407407
CERVELO S5 | 2 | 0.03703703703703703
CERVELO SOLOIST | 2 | 0.03703703703703703
CERVELO HTA | 1 | 0.01851851851851852
 |  |  |  |  |  |  |  |  |  |  | I AM USING FORMULA BELOW
 |  |  |  |  |  |  |  |  |  |  | =IF(ISNUMBER(SEARCH(L$35,$B15)),$C15,"")
 |  |  |  |  |  |  |  |  |  |  | but it returns number in column c ifor approx match
 |  |  |  |  |  |  |  |  |  |  | SEE COLUMN 58
 |  |  |  |  |  |  |  |  |  |  | I NEED A FORMULA THAT ONLY WORKS FOR AN EACT MATCH
Bicycle sales by date range & vendor |  |  | =IF(ISNUMBER(SEARCH($K$5,B6)),C6,"") |  |  |  |  |  |  | 0.2037037037037037 | 0.3333333333333333 | 0.01851851851851852 | 0.2962962962962963 | 0.07407407407407407 | 0.03703703703703703 | 0.03703703703703703
GAZELLE |  |  | =IFERROR(LOOKUP(1,-SEARCH($B$6:$B$70,K$5),C6:C70)," ") |  |  |  |  |  |  | 11 | 18 | 1 | 16 | 4 | 2 | 2
2022
Store SKU | Product Description | Qty | Total Sales | Total Cost | [NAME] | Margin | Salesperson |  |  | GAZELLE ARROYO C7 | GAZELLE ARROYO C8 | GAZELLE MEDEO T10 | GAZELLE MEDEO T10+
GAZ482005992 | GAZELLE ARROYO C7 DISC LOW [NAME] 46CM(SMALL) '22 | 1 | 3299 | 2175 | 3299 | 34.07 | [NAME]
GAZ482005992 | GAZELLE ARROYO C7 DISC LOW [NAME] 46CM(SMALL) '22 | 1 | 3299 | 2175 | 3299 | 34.07 | [NAME]
GAZ482005992 | GAZELLE ARROYO C7 DISC LOW [NAME] 46CM(SMALL) '22 | 1 | 3299 | 2045 | 3299 | 38.01 | [NAME]
GAZ482005992 | GAZELLE ARROYO C7 DISC LOW [NAME] 46CM(SMALL) '22 | 1 | 3399 | 2175 | 3399 | 36.01 | [NAME]
GAZ452444822 | GAZELLE ARROYO C7 DISC LOW [NAME] 53CM(M/L) '22 | 1 | 3299 | 2045 | 3299 | 38.01 | [NAME]
GAZ43444302 | GAZELLE ARROYO C7 DISC LOW SATURN BLUE 46CM (SMALL) '22 | 1 | 3399 | 2175 | 3399 | 36.01 | [NAME]
GAZ43444302 | GAZELLE ARROYO C7 DISC LOW SATURN BLUE 46CM (SMALL) '22 | 1 | 3299 | 2045 | 3299 | 38.01 | [NAME]
GAZ409059382 | GAZELLE ARROYO C7 DISC LOW SATURN BLUE 53CM(M/L) '22 | 1 | 3399 | 2175 | 3399 | 36.01 | [NAME]
GAZ408624752 | GAZELLE ARROYO C8 DISC LOW BLACK MATTE 53CM(M/L) '22 | 1 | 3699 | 2293 | 3699 | 38.01 | [NAME]
GAZ417991362 | GAZELLE ARROYO C8 DISC LOW BLACK MATTE 57CM(L/XL) '22 | 1 | 3699 | 2293 | 3699 | 38.01 | [NAME]
GAZ417991362 | GAZELLE ARROYO C8 DISC LOW BLACK MATTE 57CM(L/XL) '22 | 1 | 3699 | 2293 | 3699 | 38.01 | [NAME]
[NAME] | GAZELLE ARROYO C8 DISC LOW DUST LIGHT GLOSS 46CM(SMALL) '22 | 1 | 2751.6 | 2293 | 2751.6 | 16.66 | [NAME]
[NAME] | GAZELLE ARROYO C8 DISC LOW DUST LIGHT GLOSS 46CM(SMALL) '22 | 1 | 3699 | 2293 | 3699 | 38.01 | [NAME]
[NAME] | GAZELLE ARROYO C8 DISC LOW DUST LIGHT GLOSS 46CM(SMALL) '22 | 1 | 3699 | 2367 | 3699 | 36 | [NAME]
GAZ447467532 | GAZELLE ARROYO C8 DISC LOW DUST LIGHT GLOSS 53CM(M/L) '22 | 2 | 7398 | 4586 | 3699 | 38.01 | [NAME]
GAZ455161252 | GAZELLE ARROYO C8 DISC LOW DUST LIGHT GLOSS 57CM(L/XL) '22 | 1 | 3699 | 2293 | 3699 | 38.01 | [NAME]
GAZ392773431 | GAZELLE MEDEO T10 HIGH DUST GLOSS 45CM(SMALL) '22 | 1 | 3299 | 2111 | 3299 | 36.01 | [NAME]
GAZ308997512 | GAZELLE MEDEO T10 HIGH DUST GLOSS 55CM(L/XL) '22 | 1 | 3299 | 1979 | 3299 | 40.01 | [NAME]
[NAME] | GAZELLE MEDEO T10 [NAME] 45CM(SMALL) '22 | 1 | 3199 | 1983 | 3199 | 38.01 | [NAME]
GAZ393795691 | GAZELLE MEDEO T10 MID JEANS GLOSS 45CM(SMALL) '22 | 1 | 3199 | 1983 | 3199 | 38.01 | [NAME]
GAZ402225671 | GAZELLE MEDEO T10 MID JEANS GLOSS 50CM(M/L) '22 | 1 | 3199 | 1983 | 3199 | 38.01 | [NAME]
GAZ44962317L | GAZELLE MEDEO T10+ HIGH MALLARD BLUE GLOSS 45CM(SMALL) '22 | 1 | 3100 | 2282.89 | 3100 | 26.35 | [NAME]
GAZ45738052M | GAZELLE MEDEO T10+ HIGH MALLARD BLUE GLOSS 50CM(M/L) '22 | 1 | 3699 | 2293 | 3699 | 38.01 | [NAME]
GAZ466118811 | GAZELLE MEDEO T10+ HIGH MALLARD BLUE GLOSS 55CM(L/XL) '22 | 1 | 3799 | 2293 | 3799 | 39.64 | [NAME]
GAZ416187171 | GAZELLE MEDEO T10+ MID PETROL GLOSS 50CM(M/L) '22 | 1 | 3699 | 2293 | 3699 | 38.01 | [NAME]
GAZ416187171 | GAZELLE MEDEO T10+ MID PETROL GLOSS 50CM(M/L) '22 | 1 | 3699 | 2293 | 3699 | 38.01 | [NAME]
GAZ403298351 | GAZELLE MEDEO T10+ MID PETROL GLOSS 55CM(L/XL) '22 | 1 | 2770.8 | 2309 | 2770.8 | 16.66 | [NAME]
GAZ391141522 | GAZELLE MEDEO T9 CITY LOW LIGHT OLIVE 50CM(M/L) '22 | 1 | 2499 | 1425 | 2499 | 42.97 | Hector [NAME]
GAZ402976362 | GAZELLE MEDEO T9 CITY LOW MALLARD BLUE 45CM(SMALL) '22 | 1 | 2499 | 1425 | 2499 | 42.97 | [NAME]
GAZ401194492 | GAZELLE MEDEO T9 CITY LOW MALLARD BLUE 50CM(M/L) '22 | 1 | 2299 | 1425 | 2299 | 38.01 | [NAME]
GAZ401194492 | GAZELLE MEDEO T9 CITY LOW MALLARD BLUE 50CM(M/L) '22 | 1 | 2299 | 1425 | 2299 | 38.01 | [NAME]
GAZ387444791 | GAZELLE MEDEO T9 HIGH DUST GLOSS 45CM(SMALL) '22 | 1 | 2599 | 1609 | 2599 | 38.09 | [NAME]
GAZ394117781 | GAZELLE MEDEO T9 HIGH DUST GLOSS 50CM(M/L) '22 | 1 | 2599 | 1632.33 | 2599 | 37.19 | [NAME]
GAZ394117781 | GAZELLE MEDEO T9 HIGH DUST GLOSS 50CM(M/L) '22 | 1 | 2799 | 1673 | 2799 | 40.22 | [NAME]
GAZ457525021 | GAZELLE MEDEO T9 LOW CHAMPION RED GLOSS 50CM(M/L) '22 | 1 | 2599 | 1623.75 | 2599 | 37.52 | [NAME]
GAZ442176781 | GAZELLE MEDEO T9 LOW CHAMPION RED GLOSS 55CM(L/XL) '22 | 1 | 2799 | 1791 | 2799 | 36.01 | [NAME]
GAZ345884451 | GAZELLE MEDEO T9 LOW ICED BLUE GLOSS 45CM(SMALL) '22 | 1 | 2599 | 1611 | 2599 | 38.01 | [NAME]
GAZ345884451 | GAZELLE MEDEO T9 LOW ICED BLUE GLOSS 45CM(SMALL) '22 | 1 | 2799 | 1791 | 2799 | 36.01 | [NAME]
GAZ349201641 | GAZELLE ULTIMATE C380 LOW LIGHT OLIVE MATTE 46CM(SMALL) '22 | 1 | 3799 | 2719 | 3799 | 28.42 | [NAME]
GAZ346798441 | GAZELLE ULTIMATE C380 LOW LIGHT OLIVE MATTE 53CM(M/L) '22 | 1 | 4249 | 2639 | 4249 | 37.89 | [NAME]
GAZ346798441 | GAZELLE ULTIMATE C380 LOW LIGHT OLIVE MATTE 53CM(M/L) '22 | 1 | 4249 | 2634 | 4249 | 38 | [NAME]
[NAME] | GAZELLE ULTIMATE C380 LOW MALLARD BLUE MATTE 46CM(SMALL) '22 | 1 | 4249 | 2634 | 4249 | 38 | [NAME]
[NAME] | GAZELLE ULTIMATE C380 LOW MALLARD BLUE MATTE 46CM(SMALL) '22 | 1 | 4249 | 2634 | 4249 | 38 | [NAME]
[NAME] | GAZELLE ULTIMATE C380 LOW MALLARD BLUE MATTE 46CM(SMALL) '22 | 1 | 4249 | 2634 | 4249 | 38 | [NAME]
GAZ496506601 | GAZELLE ULTIMATE C380 LOW MALLARD BLUE MATTE 53CM(M/L) '22 | 1 | 4249 | 2639 | 4249 | 37.89 | [NAME]
[NAME] | GAZELLE ULTIMATE C380+ HIGH INDUSTRY GREY MATTE 53CM(M/L) '22 | 1 | 4749 | 2879 | 4749 | 39.37 | [NAME]
GAZ497673261 | GAZELLE ULTIMATE C380+ MID INDUSTRY GREY MATTE 46CM(SMALL) '22 | 1 | 4749 | 2969 | 4749 | 37.48 | [NAME]
GAZ497673261 | GAZELLE ULTIMATE C380+ MID INDUSTRY GREY MATTE 46CM(SMALL) '22 | 1 | 4749 | 2969 | 4749 | 37.48 | [NAME]
GAZ497673261 | GAZELLE ULTIMATE C380+ MID INDUSTRY GREY MATTE 46CM(SMALL) '22 | 3 | 14247 | 8882 | 4749 | 37.65 | [NAME]
GAZ507455301 | GAZELLE ULTIMATE C380+ MID INDUSTRY GREY MATTE 53CM(M/L) '22 | 1 | 4749 | 3134 | 4749 | 34 | [NAME]
GAZ507455301 | GAZELLE ULTIMATE C380+ MID INDUSTRY GREY MATTE 53CM(M/L) '22 | 1 | 4749 | 3134 | 4749 | 34 | [NAME]
GAZ507455301 | GAZELLE ULTIMATE C380+ MID INDUSTRY GREY MATTE 53CM(M/L) '22 | 1 | 4749 | 3134 | 4749 | 34 | [NAME]
GAZ496854021 | GAZELLE ULTIMATE C380+ MID INDUSTRY GREY MATTE 57CM(L/XL) '22 | 1 | 4749 | 3134 | 4749 | 34 | [NAME]
GAZ496854021 | GAZELLE ULTIMATE C380+ MID INDUSTRY GREY MATTE 57CM(L/XL) '22 | 1 | 4749 | 3134 | 4749 | 34 | [NAME]
GAZ423029151 | GAZELLE ULTIMATE C8 LOW PETROL MATTE 53CM(M/L) '22 | 2 | 7248 | 4478 | 3624 | 38.21 | [NAME]
[NAME] | GAZELLE ULTIMATE C8 LOW PETROL MATTE 57CM(L/XL) '22 | 1 | 3749 | 2309 | 3749 | 38.41 | [NAME]
[NAME] | GAZELLE ULTIMATE C8 LOW PETROL MATTE 57CM(L/XL) '22 | 1 | 3749 | 2324 | 3749 | 38.01 | [NAME]
GAZ45691828M | GAZELLE ULTIMATE T10 HIGH DUST LIGHT MATTE 53 CM(M/L) '22 | 1 | 3999 | 2488 | 3999 | 37.78 | [NAME]
GAZ44249356E | GAZELLE ULTIMATE T10 HIGH DUST LIGHT MATTE 57 CM(L/XL) '22 | 1 | 3999 | 2507 | 3999 | 37.3 | [NAME]
GAZ482632941 | GAZELLE ULTIMATE T10 LOW CHAMPION RED GLOSS 46CM(SMALL) '22 | 1 | 3999 | 2479 | 3999 | 38 | [NAME]
GAZ40732978L | GAZELLE ULTIMATE T10 LOW [NAME] 46CM(SMALL) '22 | 1 | 3999 | 2507 | 3999 | 37.3 | [NAME]
GAZ4112826M | GAZELLE ULTIMATE T10 LOW IVORY GLOSS 53CM(M/L) '22 | 1 | 3899 | 2431 | 3899 | 37.65 | [NAME]
GAZ4836751M | GAZELLE ULTIMATE T10+ HIGH CHAMPION RED GLOSS 53CM(M/L) '22 | 1 | 3999 | 2559 | 3999 | 36 | Hector [NAME]
GAZ4836751M | GAZELLE ULTIMATE T10+ HIGH CHAMPION RED GLOSS 53CM(M/L) '22 | 1 | 4199 | 2603 | 4199 | 38 | [NAME]
GAZ493067981 | GAZELLE ULTIMATE T10+ HIGH CHAMPION RED GLOSS 57CM(L/XL) '22 | 1 | 4199 | 2603 | 4199 | 38 | [NAME]
GAZ493067981 | GAZELLE ULTIMATE T10+ HIGH CHAMPION RED GLOSS 57CM(L/XL) '22 | 1 | 4199 | 2603 | 4199 | 38 | [NAME]
GAZ493067981 | GAZELLE ULTIMATE T10+ HIGH CHAMPION RED GLOSS 57CM(L/XL) '22 | 1 | 4499 | 2603 | 4499 | 42.14 | [NAME]
GAZ452495192 | GAZELLE ULTIMATE T10+ HIGH ORION BLUE MATTE 57CM(L/XL) '22 | 1 | 4199 | 2603 | 4199 | 38 | [NAME]
GAZ329904592 | GAZELLE ULTIMATE T10+ MID DUST LIGHT GLOSS 53CM(M/L) '22 | 1 | 4199 | 2603 | 4199 | 38 | [NAME]
GAZ329904592 | GAZELLE ULTIMATE T10+ MID DUST LIGHT GLOSS 53CM(M/L) '22 | 1 | 4199 | 2573.66 | 4199 | 38.7 | [NAME]
GAZ465955421 | GAZELLE ULTIMATE T10+ MID DUST LIGHT GLOSS 57CM(L/XL) '22 | 1 | 4199 | 2559 | 4199 | 39.05 | [NAME]