Spreadsheet: 848898d1699508704-multiple-criteria-lookup-with-a-range-help
Sheet: Ratecard

Name | Product | Min Sqft | [NAME] | Rate | Trainer Rate
Ajay | Herringbone | 0 | 224 | daily rate | daily rate
Ajay | Herringbone | 225 |  | 0.24
Ajay | Herringbone |  |  | 0.24
Ajay | Herringbone |  |  | 0.24
Ajay | Herringbone |  |  | 0.28
Ajay | Herringbone |  |  | 0.28
Ajay | Herringbone |  |  | 0.28
Ajay | With Skirting | 0 |  | daily rate | daily rate
Ajay | With Skirting | 450 |  | 0.12 | 0.13
Ajay | With Skirting |  |  | 0.12 | 0.13
Ajay | With Skirting |  |  | 0.12 | 0.13
Ajay | With Skirting |  |  | 0.14 | 0.15
Ajay | With Skirting |  |  | 0.14 | 0.15
Ajay | With Skirting |  |  | 0.14 | 0.15
Ajay | Without Skirting | 0 |  | daily rate | daily rate
Ajay | Without Skirting | 500 |  | 0.1
Ajay | Without Skirting |  |  | 0.1
Ajay | Without Skirting |  |  | 0.12
Ajay | Without Skirting |  |  | 0.12
Ajay | Without Skirting |  |  | 0.12
Ajay | Without Skirting |  |  | 0.14
Ajay | Without Skirting |  |  | 0.14
Dipu | Herringbone | 0 |  | daily rate | daily rate
Dipu | Herringbone | 225 |  | 0.22 | 0
Dipu | Herringbone | 250 |  | 0.22 | 0
Dipu | Herringbone | 275 |  | 0.24 | 0
Dipu | Herringbone | 300 |  | 0.24 | 0
Dipu | Herringbone | 325 |  | 0.26 | 0
Dipu | Herringbone | 350 |  | 0.26 | 0
Dipu | With Skirting | 0 |  | daily rate | daily rate
Dipu | With Skirting | 450 |  | 0.11 | 0
Dipu | With Skirting | 500 |  | 0.11 | 0
Dipu | With Skirting | 550 |  | 0.12 | 0
Dipu | With Skirting | 600 |  | 0.12 | 0
Dipu | With Skirting | 650 |  | 0.13 | 0
Dipu | With Skirting | 700 |  | 0.13 | 0
Dipu | Without Skirting | 0 |  | daily rate | daily rate
Dipu | Without Skirting | 500 |  | 0.09 | 0
Dipu | Without Skirting | 550 |  | 0.1 | 0
Dipu | Without Skirting | 600 |  | 0.1 | 0
Dipu | Without Skirting | 650 |  | 0.11 | 0
Dipu | Without Skirting | 700 |  | 0.11 | 0
Dipu | Without Skirting | 750 |  | 0.12 | 0
Dipu | Without Skirting | 800 |  | 0.12 | 0
[NAME] | Herringbone | 0 |  | daily rate | daily rate
[NAME] | Herringbone | 225 |  | 0.2 | 0
[NAME] | Herringbone |  |  | 0.2 | 0
[NAME] | Herringbone |  |  | 0.22 | 0
[NAME] | Herringbone |  |  | 0.22 | 0
[NAME] | Herringbone |  |  | 0.24 | 0
[NAME] | Herringbone |  |  | 0.24 | 0
[NAME] | With Skirting | 0 |  | daily rate | daily rate
[NAME] | With Skirting | 450 |  | 0.1 | 0
[NAME] | With Skirting | 500 |  | 0.1 | 0
[NAME] | With Skirting | 550 |  | 0.11 | 0
[NAME] | With Skirting | 600 |  | 0.11 | 0
[NAME] | With Skirting | 650 |  | 0.12 | 0
[NAME] | With Skirting | 700 |  | 0.12 | 0
[NAME] | Without Skirting | 0 |  | daily rate | daily rate
[NAME] | Without Skirting | 500 |  | 0.08 | 0
[NAME] | Without Skirting |  |  | 0.09 | 0
[NAME] | Without Skirting |  |  | 0.09 | 0
[NAME] | Without Skirting |  |  | 0.1 | 0
[NAME] | Without Skirting |  |  | 0.1 | 0
[NAME] | Without Skirting |  |  | 0.11 | 0
[NAME] | Without Skirting |  |  | 0.11 | 0
Muthiah | Herringbone | 0 |  | daily rate | daily rate
Muthiah | Herringbone | 225 |  | 0.22 | 0
Muthiah | Herringbone |  |  | 0.22 | 0
Muthiah | Herringbone |  |  | 0.24 | 0
Muthiah | Herringbone |  |  | 0.24 | 0
Muthiah | Herringbone |  |  | 0.26 | 0
Muthiah | Herringbone |  |  | 0.26 | 0
Muthiah | With Skirting | 0 |  | daily rate | daily rate
Muthiah | With Skirting | 450 |  | 0.11 | 0
Muthiah | With Skirting |  |  | 0.11 | 0
Muthiah | With Skirting |  |  | 0.12 | 0
Muthiah | With Skirting |  |  | 0.12 | 0
Muthiah | With Skirting |  |  | 0.13 | 0
Muthiah | With Skirting |  |  | 0.13 | 0
Muthiah | Without Skirting | 0 |  | daily rate | daily rate
Muthiah | Without Skirting | 500 |  | 0.09 | 0
Muthiah | Without Skirting |  |  | 0.1 | 0
Muthiah | Without Skirting |  |  | 0.1 | 0
Muthiah | Without Skirting |  |  | 0.11 | 0
Muthiah | Without Skirting |  |  | 0.11 | 0
Muthiah | Without Skirting |  |  | 0.12 | 0
Muthiah | Without Skirting |  |  | 0.12 | 0
Raja | Herringbone | 0 |  | daily rate | daily rate
Raja | Herringbone | 225 |  | 0.24
Raja | Herringbone |  |  | 0.24
Raja | Herringbone |  |  | 0.24
Raja | Herringbone |  |  | 0.28
Raja | Herringbone |  |  | 0.28
Raja | Herringbone |  |  | 0.28
Raja | With Skirting | 0 |  | daily rate | daily rate
Raja | With Skirting | 450 |  | 0.12 | 0.13
Raja | With Skirting |  |  | 0.12 | 0.13
Raja | With Skirting |  |  | 0.12 | 0.13
Raja | With Skirting |  |  | 0.14 | 0.15
Raja | With Skirting |  |  | 0.14 | 0.15
Raja | With Skirting |  |  | 0.14 | 0.15
Raja | Without Skirting | 0 |  | daily rate | daily rate
Raja | Without Skirting | 500 |  | 0.1
Raja | Without Skirting |  |  | 0.12
Raja | Without Skirting |  |  | 0.12
Raja | Without Skirting |  |  | 0.12
Raja | Without Skirting |  |  | 0.14
Raja | Without Skirting |  |  | 0.14
Raja | Without Skirting |  |  | 0.14
Rasu | Herringbone | 0 |  | daily rate | daily rate
Rasu | Herringbone | 225 |  | 0.22 | 0
Rasu | Herringbone |  |  | 0.22 | 0
Rasu | Herringbone |  |  | 0.24 | 0
Rasu | Herringbone |  |  | 0.24 | 0
Rasu | Herringbone |  |  | 0.26 | 0
Rasu | Herringbone |  |  | 0.26 | 0
Rasu | With Skirting | 0 |  | daily rate | daily rate
Rasu | With Skirting | 450 |  | 0.11 | 0
Rasu | With Skirting | 500 |  | 0.11 | 0
Rasu | With Skirting |  |  | 0.12 | 0
Rasu | With Skirting |  |  | 0.12 | 0
Rasu | With Skirting |  |  | 0.13 | 0
Rasu | With Skirting |  |  | 0.13 | 0
Rasu | Without Skirting | 0 |  | daily rate | daily rate
Rasu | Without Skirting | 500 |  | 0.09 | 0
Rasu | Without Skirting |  |  | 0.1 | 0
Rasu | Without Skirting |  |  | 0.1 | 0
Rasu | Without Skirting |  |  | 0.11 | 0
Rasu | Without Skirting |  |  | 0.11 | 0
Rasu | Without Skirting |  |  | 0.12 | 0
Rasu | Without Skirting |  |  | 0.12 | 0
[NAME] | Herringbone | 0 |  | daily rate | daily rate
[NAME] | Herringbone | 150 |  | 0.16 | 0
[NAME] | Herringbone | 200 |  | 0.18 | 0
[NAME] | Herringbone |  |  | 0.2 | 0
[NAME] | Herringbone |  |  | 0.2 | 0
[NAME] | Herringbone |  |  | 0.2 | 0
[NAME] | Herringbone |  |  | 0.22 | 0
[NAME] | Herringbone |  |  | 0.22 | 0
[NAME] | Herringbone |  |  | 0.24 | 0
[NAME] | With Skirting | 0 |  | daily rate | daily rate
[NAME] | With Skirting | 300 |  | 0.08 | 0
[NAME] | With Skirting | 400 |  | 0.09 | 0
[NAME] | With Skirting | 450 |  | 0.1 | 0
[NAME] | With Skirting | 500 |  | 0.1 | 0
[NAME] | With Skirting | 550 |  | 0.1 | 0
[NAME] | With Skirting | 600 |  | 0.11 | 0
[NAME] | With Skirting | 650 |  | 0.11 | 0
[NAME] | With Skirting | 700 |  | 0.12 | 0
[NAME] | Without Skirting | 0 |  | daily rate | daily rate
[NAME] | Without Skirting | 400 |  | 0.07 | 0
[NAME] | Without Skirting |  |  | 0.08 | 0
[NAME] | Without Skirting |  |  | 0.08 | 0
[NAME] | Without Skirting |  |  | 0.08 | 0
[NAME] | Without Skirting |  |  | 0.09 | 0
[NAME] | Without Skirting |  |  | 0.09 | 0
[NAME] | Without Skirting |  |  | 0.1 | 0
Suresh | Herringbone | 0 |  | daily rate | daily rate
Suresh | Herringbone | 225 |  | 0.2 | 0
Suresh | Herringbone |  |  | 0.2 | 0
Suresh | Herringbone |  |  | 0.22 | 0
Suresh | Herringbone |  |  | 0.22 | 0
Suresh | Herringbone |  |  | 0.24 | 0
Suresh | Herringbone |  |  | 0.24 | 0
Suresh | With Skirting | 0 |  | daily rate | daily rate
Suresh | With Skirting | 450 |  | 0.1 | 0
Suresh | With Skirting |  |  | 0.1 | 0
Suresh | With Skirting |  |  | 0.11 | 0
Suresh | With Skirting |  |  | 0.11 | 0
Suresh | With Skirting |  |  | 0.12 | 0
Suresh | With Skirting |  |  | 0.12 | 0
Suresh | Without Skirting | 0 |  | daily rate | daily rate
Suresh | Without Skirting | 500 |  | 0.08 | 0
Suresh | Without Skirting |  |  | 0.09 | 0
Suresh | Without Skirting |  |  | 0.09 | 0
Suresh | Without Skirting |  |  | 0.1 | 0
Suresh | Without Skirting |  |  | 0.1 | 0
Suresh | Without Skirting |  |  | 0.11 | 0
Suresh | Without Skirting |  |  | 0.11 | 0
Vinoth | Herringbone | 0 |  | daily rate | daily rate
Vinoth | Herringbone | 225 |  | 0.26 | 0.28
Vinoth | Herringbone |  |  | 0.26 | 0.28
Vinoth | Herringbone |  |  | 0.26 | 0.28
Vinoth | Herringbone |  |  | 0.3 | 0.32
Vinoth | Herringbone |  |  | 0.3 | 0.32
Vinoth | Herringbone |  |  | 0.3 | 0.32
Vinoth | With Skirting | 0 |  | daily rate | daily rate
Vinoth | With Skirting | 450 |  | 0.13 | 0.14
Vinoth | With Skirting |  |  | 0.13 | 0.14
Vinoth | With Skirting |  |  | 0.13 | 0.14
Vinoth | With Skirting |  |  | 0.15 | 0.16
Vinoth | With Skirting |  |  | 0.15 | 0.16
Vinoth | With Skirting |  |  | 0.15 | 0.16
Vinoth | Without Skirting | 0 |  | daily rate | daily rate
Vinoth | Without Skirting | 500 |  | 0.11
Vinoth | Without Skirting |  |  | 0.11
Vinoth | Without Skirting |  |  | 0.13 | 0.14
Vinoth | Without Skirting |  |  | 0.13
Vinoth | Without Skirting |  |  | 0.13
Vinoth | Without Skirting |  |  | 0.15
Vinoth | Without Skirting |  |  | 0.15