Spreadsheet: 738164d1624881232-ifs-with-nested-vlookup-ifs-vlookup-test-1-
Sheet: Formulas

Payment Types |  |  | Postcodes |  |  | Regions |  |  | Orientation
Cash | 0 |  | AB | 16 |  | 1 | Zone 1 - London |  | 0
Loan @ 4.9% | 0.049 |  | AL | 1 |  | 2 | Zone 2 - Brighton |  | 5
Loan @ 9.7% | 0.097 |  | B | 6 |  | 3 | Zone 3 - Southampton |  | 10
 |  |  | BA | 5E |  | 4 | Zone 4 - Plymouth |  | 15
 |  |  | BB | 7E |  | 5E | Zone 5E - Bristol |  | 20
Payment Terms |  |  | BD | 11 |  | 5W | Zone 5W - Cardiff |  | 25
0 |  |  | BD23-24 | 10 |  | 6 | Zone 6 - Birmingham |  | 30
1 |  |  | BH | 3 |  | 7E | Zone 7E - Manchester |  | 35
2 |  |  | BL | 7E |  | 7W | Zone 7W - Chester |  | 40
3 |  |  | BN | 2 |  | 8S | Zone 8S - Dumfries |  | 45
4 |  |  | BR | 2 |  | 8E | Zone 8E - Carlisle |  | 50
5 |  |  | BS | 5E |  | 9E | Zone 9E - Newcastle |  | 55
6 |  |  | BT | 21 |  | 9S | Zone 9S - Edinburgh |  | 60
7 |  |  | CA | 8E |  | 10 | Zone 10 - Middlesborough |  | 65
8 |  |  | CB | 12 |  | 11 | Zone 11 - Sheffield |  | 70
9 |  |  | CF | 5W |  | 12 | Zone 12 - Norwich |  | 75
10 |  |  | CH | 7E |  | 13 | Zone 13 - Aberystwith |  | 80
11 |  |  | CH5-8 | 7W |  | 14 | Zone 14 - Glasgow |  | 85
12 |  |  | CM | 12 |  | 15 | Zone 15 - Dundee |  | 90
13 |  |  | CM21-23 | 1 |  | 16 | Zone 16 - Aberdeen |  | 95
14 |  |  | CO | 12 |  | 17 | Zone 17 - Inverness |  | 100
15 |  |  | CR | 1 |  | 18 | Zone 18 - Stornoway (TBC) |  | 105
 |  |  | CT | 2 |  | 19 | Zone 19 - Kirkwall (TBC) |  | 110
 |  |  | [NAME] | 6 |  | 20 | Zone 20 - Lerwick TBC |  | 115
 |  |  | CW | 7E |  | 21 | Zone 21 - Belfast |  | 120
 |  |  | DA | 2 |  |  |  |  | 125
 |  |  | DD | 15 |  |  |  |  | 130
 |  |  | DE | 6 |  |  |  |  | 135
 |  |  | DG | 8S |  |  |  |  | 140
 |  |  | DH | 10 |  |  |  |  | 145
 |  |  | DH4-5 | 9E |  |  |  |  | 150
 |  |  | DL | 10 |  |  |  |  | 155
 |  |  | DN | 11 |  |  |  |  | 160
 |  |  | DT | 3 |  |  |  |  | 165
 |  |  | DY | 6 |  |  |  |  | 170
 |  |  | E | 1 |  |  |  |  | 175
 |  |  | EC | 1
 |  |  | EH | 15
 |  |  | EH43-46 | 9S
 |  |  | EN | 1
 |  |  | EN9 | 12
 |  |  | EX | 4
 |  |  | FK | 14
 |  |  | FY | 7E
 |  |  | G | 14
 |  |  | GL | 5E
 |  |  | GU | 1
 |  |  | GU11-12 | 3
 |  |  | GU14 | 3
 |  |  | GU28-29 | 2
 |  |  | GU30-35 | 3
 |  |  | GU46 | 3
 |  |  | GU51-52 | 3
 |  |  | HA | 1
 |  |  | HD | 11
 |  |  | HG | 10
 |  |  | HP | 1
 |  |  | HR | 6
 |  |  | HS | 18
 |  |  | [NAME] | 11
 |  |  | HX | 11
 |  |  | IG | 12
 |  |  | IP | 12
 |  |  | IV | 17
 |  |  | IV30-32 | 16
 |  |  | IV36 | 16
 |  |  | KA | 14
 |  |  | KT | 1
 |  |  | KW | 17
 |  |  | KW15-17 | 19
 |  |  | KY | 15
 |  |  | L | 7E
 |  |  | LA | 7E
 |  |  | LA7-23 | 8E
 |  |  | LD | 13
 |  |  | LE | 6
 |  |  | LL | 7W
 |  |  | LL23-27 | 13
 |  |  | LL30-78 | 13
 |  |  | LN | 11
 |  |  | LS | 11
 |  |  | LS24 | 10
 |  |  | LU | 1
 |  |  | M | 7E
 |  |  | ME | 2
 |  |  | MK | 1
 |  |  | ML | 14
 |  |  | N | 1
 |  |  | NE | 9E
 |  |  | NG | 11
 |  |  | NN | 6
 |  |  | NP | 5W
 |  |  | NPS | 13
 |  |  | NR | 12
 |  |  | NW | 1
 |  |  | OL | 7E
 |  |  | OX | 1
 |  |  | PA | 14
 |  |  | PE | 12
 |  |  | PE20-25 | 11
 |  |  | PE9-12 | 11
 |  |  | PH | 15
 |  |  | PH19-25 | 17
 |  |  | PH26 | 16
 |  |  | PH30-44 | 17
 |  |  | PH49 | 14
 |  |  | PH50 | 14
 |  |  | PL | 4
 |  |  | PO | 3
 |  |  | PO18-22 | 2
 |  |  | PR | 7E
 |  |  | RG | 1
 |  |  | RG21-29 | 3
 |  |  | RH | 1
 |  |  | RH10-20 | 2
 |  |  | RH77 | 2
 |  |  | RM | 12
 |  |  | S | 11
 |  |  | S18 | 6
 |  |  | S32-33 | 6
 |  |  | S40-45 | 6
 |  |  | S49 | 6
 |  |  | SA | 5W
 |  |  | SA14-20 | 13
 |  |  | SA31-48 | 13
 |  |  | SA61-73 | 13
 |  |  | SE | 1
 |  |  | SG | 1
 |  |  | SK | 7E
 |  |  | SK13 | 6
 |  |  | SK17 | 6
 |  |  | SK22-23 | 6
 |  |  | SL | 1
 |  |  | SM | 1
 |  |  | SN | 5E
 |  |  | SN7 | 1
 |  |  | SO | 3
 |  |  | SP | 5E
 |  |  | SP6-11 | 3
 |  |  | SR | 9E
 |  |  | SR7-8 | 10
 |  |  | SS | 12
 |  |  | ST | 6
 |  |  | SW | 1
 |  |  | SY | 6
 |  |  | SY14 | 7E
 |  |  | SY15-25 | 13
 |  |  | TA | 5E
 |  |  | TD | 9S
 |  |  | TD12 | 9E
 |  |  | TD15 | 9E
 |  |  | TF | 6
 |  |  | TN | 2
 |  |  | TQ | 4
 |  |  | TR | 4
 |  |  | TS | 10
 |  |  | TW | 1
 |  |  | UB | 1
 |  |  | W | 1
 |  |  | WA | 7E
 |  |  | WC | 1
 |  |  | WD | 1
 |  |  | WF | 11
 |  |  | WN | 7E
 |  |  | WR | 6
 |  |  | WS | 6
 |  |  | WV | 6
 |  |  | YO | 10
 |  |  | YO15-16 | 11
 |  |  | YO25 | 11
 |  |  | ZE | 20