First, normalize your reference table. It is easier to do this when you don't have to reference from range of values (1-19).

```
Hardlines Tier 0 | 150 | 2
Hardlines Tier 1 | 20 | 1
Hardlines Tier 2 | 1 | 0.5
Softlines Tier 0 | 100 | 2
Softlines Tier 1 | 20 | 1
Softlines Tier 2 | 1 | 0.5
Media Tier 0 | 500 | 2
Media Tier 1 | 20 | 1
Media Tier 2 | 1 | 0.5
```

Please note that the ranges of value is sorted **DESCENDING** (150 > 20 > 1)

After that, insert this formula into your Points column.

```
=INDEX($N$1:$N$9, MATCH(1, (B1 >= $M$1:$M$9) * (C1 = $K$1:$K$9), 0))
```

and press `Ctrl+Shift+Enter` instead of `Enter` to insert the array formula.

The formula is looking for `Points`

referenced in column N, which matching two criteria :

`B1 >= $M$1:$M$9`

The value on lookup is higher than the referenced values in column M.

`C1 = $K$1:$K$9`

The value on lookup is matching the referenced string in column K.