Spreadsheet: 823785d1680137559-formula-match-range-and-search-barrytest
Sheet: Sheet1

 |  |  |  | VEND DATA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LIST OF  BIKES TO BUY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IFERROR(LOOKUP(1,-SEARCH($F$6:$F$1000,L6),$D$6:$D$1000)," ")
 |  |  |  | SKU | Brand | [NAME] | Color | Size | Year | StyleNumber | StyleName     - MODEL | Cost | Msrp |  |  |  |  |  |  |  |  |  |  |  |  |  | MODELS TO STOCK
 |  |  |  | [PHONE] |  |  | Matte Metallic Gunmetal | L |  |  | 1120 F/S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1120
 |  |  |  | [PHONE] |  |  | [NAME] | M |  |  | 1120 F/S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALLANT+ 7 US
 |  |  |  | [PHONE] |  |  | Matte Metallic Gunmetal | M |  |  | ALLANT+ 7 US |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST2
 |  |  |  | [PHONE] |  |  | [NAME] | S |  |  | DFGDFGFD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Checkpoint
 |  |  |  | [PHONE] |  |  | Carbon Smoke/Lithium Grey/Trek Black | 52 |  |  | ALLANT+ 7 US |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST3
 |  |  |  | [PHONE] |  |  | Carbon Smoke/Lithium Grey/Trek Black | 54 |  |  | ALLANT+ 7S STAGGER US |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CROCKET
 |  |  |  | [PHONE] |  |  | Carbon Smoke/Lithium Grey/Trek Black | 56 |  |  | ALLANT+ 7S STAGGER US |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Carbon Smoke/Lithium Grey/Trek Black | 52 |  |  | ALLANT+ 7S US |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Radioactive Red to Navy to [NAME] | 52 |  |  | ALLANT+ 7S US |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Carbon Smoke/Lithium Grey/Trek Black | 54 |  |  | ALLANT+ 8S STAGGER US |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Radioactive Red to Navy to [NAME] | 54 |  |  | ALLANT+ 8S STAGGER US |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Carbon Smoke/Lithium Grey/Trek Black | 56 |  |  | ALLANT+ 8S STAGGER US |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Radioactive Red to Navy to [NAME] | 56 |  |  | ALLANT+ 8S STAGGER US |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Era White/Trek Black | 52 |  |  | BOONE 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Satin Nautical Navy/Satin Red | 52 |  |  | BOONE 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Era White/Trek Black | 54 |  |  | BOONE 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Satin Nautical Navy/Satin Red | 54 |  |  | BOONE DISC F/S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Era White/Trek Black | 56 |  |  | BOONE DISC F/S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Satin Nautical Navy/Satin Red | 56 |  |  | BOONE DISC F/S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Era White/Trek Black | 58 |  |  | BOONE DISC F/S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Satin Nautical Navy/Satin Red | 58 |  |  | Checkpoint ALR 5 52 Era White/Trek Black |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Era White/Trek Black | 52 |  |  | Checkpoint ALR 5 52 Satin Nautical Navy/Satin Red |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Satin Nautical Navy/Satin Red | 54 |  |  | Checkpoint ALR 5 54 Era White/Trek Black |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Era White/Trek Black | 54 |  |  | Checkpoint ALR 5 54 Satin Nautical Navy/Satin Red |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Satin Nautical Navy/Satin Red | 56 |  |  | Checkpoint ALR 5 56 Era White/Trek Black |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [PHONE] |  |  | Era White/Trek Black | 56 |  |  | Checkpoint ALR 5 56 Satin Nautical Navy/Satin Red |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] |  |  | [NAME] | [NAME] |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] |  |  | [NAME] | [NAME] |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]