Spreadsheet: 454547d1459878884-lookup-match-and-a-number-range-example-2
Sheet: Tab1

 |  |  |  |  |  |  |  | Product Code |  |  |  |  |  |  |  |  |  |  | Quantity |  |  |  |  |  |  | Current Rate |  |  |  |  |  |  |  | Quantity | Price
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 315 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product 1 | Product 2 | Product 3
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1000 | 5000 | 500
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 390 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 700 | 4000 | 500
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | 500 | 3500 | 400
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 400 | 3000 | 300
 |  |  |  |  |  |  |  | Product 1 |  |  |  |  |  |  |  |  |  |  | 650 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100000 | 300 | 2500 | 200
 |  |  |  |  |  |  |  | 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