Spreadsheet: 586122d1534210605-trying-to-create-a-simple-price-list-from-a-table-is-driving-me-nuts-help-needed-please-data-validation-cascading-dv-with-autocomplete
Sheet: Data

Brand | Product | Price |  |  | Brand |  | you can hide column F if you want
3D FURY | 3D Fury Hdmi-Comp | 325
[NAME] | Con4 Lg Smart Tv | 333 |  |  |  |  | Column F is a Unique Brand list column
ADA | Suite 8300 | 3376 |  |  |  |  | formula used
ALDOUS | Cat6/Jack Grey | 4.58 |  |  |  |  | =IFERROR(INDEX(BrandList,MATCH(0,COUNTIF($F$1:F1,BrandList),0)),"")
ALDOUS | Home Net/Wk Cab Lrg | 250
ALDOUS | 1U/Cat5 12 Way Patch | 37.5
ALDOUS | 1U/20Way F-Panel | 33.5
ALDOUS | 4U/Blank Full Length | 20
ALDOUS | 1U/12Way F-Panel | 25.5
ALDOUS | 1U/Adapter Plt 8Way | 19.75
ALDOUS | 1U Brush Panel | 16.95
ALDOUS | 1U/Blank Panel Full | 11.65
ALDOUS | 1U/Modular Pat Panel | 22.5
ALDOUS | Home Net/Wk Cab Med | 205.37
ALLTRADE | 2Way 'F' Splitter | 7
ALLTRADE | 3Way 'F' Splitter | 12
ALLTRADE | 4Way 'F' Splitter | 15
ALLTRADE | 6Way 'F' Splitter | 30
ALLTRADE | 8Way 'F' Splitter | 40
ALPHASON | Iconn St860 120 Tabl | 599
ALPHASON | [NAME] | 25
Angry Orchard | Con4 Lg Smart Tv | 238
ANNEX4 | Nail File | 150
Arsenal Cider House | Box | 135
Aspall Cider | Pillow | 354
[NAME] | Food | 262
Black Star | Apple | 34
Blackthorn Cider | Nail Clippers | 293
[NAME] | Button | 124
Brothers Cider | Tomato | 64
Bulmers | [NAME] | 145
Burrow Hill Cider | Truck | 220
Carling Cider | Sailboat | 315
Ciderboys | Hair Tie | 346
[NAME] | Bracelet | 160
Downeast Cider House | Sun Glasses | 95
Fizz | Tree | 132
[NAME] | Cork | 300
[NAME] | [NAME] | 206
Gaymer Cider Company | Street Lights | 332
[NAME] | Brocolli | 355
[NAME] | Model Car | 118
[NAME] | [NAME] | 198
K Cider | [NAME] | 219
Kingstone Press Cider | White Out | 386
Kopparbergs | [NAME] | 288
Magners Irish Cider (see [NAME]) | Sharpie | 366
Merrydown | Coasters | 108
Monteiths Crushed Apple Cider | Cat | 33
Old Rosie | Box | 199
Pomagne produced by Bulmers | Bottle | 141
[NAME] | Beef | 174
[NAME] | Tree | 228
Savanna Dry | Sun Glasses | 266
[NAME] | Paint Brush | 245
Scrumpy [NAME] by Bulmer | Photo Album | 73
Somersby cider | Keyboard | 116
[NAME] cidre brand | Shovel | 331
Strongbow cider | [NAME] | 262
[NAME] | Toilet | 213
Taunton Cider Company | Money | 139
Taunton Cider Company | Pencil | 70
Taunton Cider Company | [NAME] | 60
Taunton Cider Company | Book | 187
Taunton Cider Company | Sofa | 171
Taunton Cider Company | [NAME] | 357
Taunton Cider Company | [NAME] | 364
Taunton Cider Company | [NAME] | 125
Taunton Cider Company | Fake Flowers | 351
Taunton Cider Company | Cell Phone | 157
Taunton Cider Company | Bracelet | 187
Taunton Cider Company | Sandal | 278
Taunton Cider Company | Soy Sauce Packet | 116
Taunton Cider Company | [NAME] | 116
Taunton Cider Company | Drawer | 116
Taunton Cider Company | [NAME] | 116
Taunton Cider Company | Lamp Shade | 116
Thatchers Cider | Desk | 69
Three Hammers | Food | 299
White Star | Sidewalk | 46
Woodchuck Hard Cider | Remote | 45
Woodpecker Cider | Conditioner | 108
Woodpecker Cider | Tv | 261
Woodpecker Cider | Fake Flowers | 355
Woodpecker Cider | [NAME] | 120
Woodpecker Cider | Outlet | 174
Woodpecker Cider | Box | 304
Woodpecker Cider | Monitor | 371
Woodpecker Cider | Bookmark | 204
Woodpecker Cider | [NAME] | 307
Woodpecker Cider | Button | 323
Woodpecker Cider | Pants | 113
Woodpecker Cider | Monitor | 288