Spreadsheet: 454742d1459959459-lookup-match-and-a-number-range-example-2
Sheet: Tab1

 |  |  |  |  |  |  |  | Product Code |  |  |  |  |  |  |  |  |  |  | Quantity |  |  |  |  |  |  | Current Rate
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 315
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 390
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 650
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 350
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 250
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 300
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 50000
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 10436
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 6296
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 4030
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 7008
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 2702
 |  |  |  |  |  |  |  | Product 2 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 10436
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 7008
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 160
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 2767
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 440
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 300
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 408
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 196
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 132
 |  |  |  |  |  |  |  | Product 3 |  |  |  |  |  |  |  |  |  |  | 31