SHEET 1

SHEET 2

SHEET 3

I need to calculate the number of international companies (sheet 3) as a difference between total companies (sheet 1) and local companies (sheet 2). The list is not in order so I cannot just do the simple formula of subtracting. Ive done the task using VLOOKUP for locating the right number of total companies for a municipality, and from that subtracting the number of local companies using again VLOOKUP. I wanted to know if there is any other formula that I can use that is more efficient and easier that VLOOKUP. Thank you

Municipality District 2008 2009 2010 2011 2012 Average Average CAGR CAGR direct manual direct manual formula formula formula formula Change in No. of businesse S 165 219 181 269 137 475 198 153 206 152 206 152 148 174 399 431 338 445 148 412 417 509 445 445 404 455 367 404 257 251 251 Albufeira Alcobaa Almada Amadora Aveiro Barcelos Braga Caldas da Rainha Cascais Coimbra 266 310 236 373 366 322 322 Faro Leiria Setbal Lisboa Aveiro Braga Braga Leiria Lisboa Coimbra vora Faro Porto 231 254 570 143 639 771 709 665 665 264 306 635 132 887 406 -7.6% 1.6% -2.8% -1.7% -2.4% 3.8% 2.1% -5.2% -0.6% 0.0% -5.5% -3.3% -1.2% -7.6% Decrease 1.6% Increase -2.8% Decrease -1.7% Decrease -2.4% Decrease 3.8% Increase 2.1% Increase -5.2% Decrease -0.6% Decrease 0.0% Increase -5.5% Decrease -3.3% Decrease -1.2% Decrease 159 133 148 174 906 416 799 403 879 417 148 913 417 Evora 191 176 1095 445 162 200 255 170 144 187 913 417 170 200 205 179 200 193 Faro Felgueiras 200 221 220 191 151 207 205 Municipali District 2008 2009 2010 2011 2012 189 142 120 163 149 137 486 435 Albufeira Faro Alcobaa Leiria Almada Setbal Amadora Lisboa Aveiro Aveiro Barcelos Braga Braga Braga Caldas da Leiria Cascais Lisboa Coimbra Coimbra Evora vora Faro Faro Felgueiras Porto Funchal Madeira 114 420 410 240 300 620 161 420 328 253 300 625 150 102 300 341 204 248 540 136 777 390 169 175 130 150 113 401 399 229 368 700 120 859 400 140 247 357 740 136 1000 425 160 122 865 398 886 402 181 205 190 123 190 180 167 190 150 426 200 513 182 414 Inicipality District 2012 10 12 14 14 11 82 14 3 95 10 18 16 10 16 6 32 10 3 8 13 22 3 35 3 9 56 13 15 7 38 10 5 7 prres Vedras Lisboa ntra Lisboa etbal Setbal voa de Varzim Porto orto Porto ortimo Faro enafiel Porto aredes Porto almela Setbal aos de Ferreira Porto lontijo Setbal latosinhos Porto laia Porto lafra Lisboa shna Lisboa 21 8 9 10 1 24 7 1 29 9 9 20 53 26 19 22 22 54 14 10 10 10 4 24 8 10 22 20 18 10 8 19 21 15 33 30 19 20 53 92 78 48 84 Municipality District 2008 2009 2010 2011 2012 Average Average CAGR CAGR direct manual direct manual formula formula formula formula Change in No. of businesse S 165 219 181 269 137 475 198 153 206 152 206 152 148 174 399 431 338 445 148 412 417 509 445 445 404 455 367 404 257 251 251 Albufeira Alcobaa Almada Amadora Aveiro Barcelos Braga Caldas da Rainha Cascais Coimbra 266 310 236 373 366 322 322 Faro Leiria Setbal Lisboa Aveiro Braga Braga Leiria Lisboa Coimbra vora Faro Porto 231 254 570 143 639 771 709 665 665 264 306 635 132 887 406 -7.6% 1.6% -2.8% -1.7% -2.4% 3.8% 2.1% -5.2% -0.6% 0.0% -5.5% -3.3% -1.2% -7.6% Decrease 1.6% Increase -2.8% Decrease -1.7% Decrease -2.4% Decrease 3.8% Increase 2.1% Increase -5.2% Decrease -0.6% Decrease 0.0% Increase -5.5% Decrease -3.3% Decrease -1.2% Decrease 159 133 148 174 906 416 799 403 879 417 148 913 417 Evora 191 176 1095 445 162 200 255 170 144 187 913 417 170 200 205 179 200 193 Faro Felgueiras 200 221 220 191 151 207 205 Municipali District 2008 2009 2010 2011 2012 189 142 120 163 149 137 486 435 Albufeira Faro Alcobaa Leiria Almada Setbal Amadora Lisboa Aveiro Aveiro Barcelos Braga Braga Braga Caldas da Leiria Cascais Lisboa Coimbra Coimbra Evora vora Faro Faro Felgueiras Porto Funchal Madeira 114 420 410 240 300 620 161 420 328 253 300 625 150 102 300 341 204 248 540 136 777 390 169 175 130 150 113 401 399 229 368 700 120 859 400 140 247 357 740 136 1000 425 160 122 865 398 886 402 181 205 190 123 190 180 167 190 150 426 200 513 182 414 Inicipality District 2012 10 12 14 14 11 82 14 3 95 10 18 16 10 16 6 32 10 3 8 13 22 3 35 3 9 56 13 15 7 38 10 5 7 prres Vedras Lisboa ntra Lisboa etbal Setbal voa de Varzim Porto orto Porto ortimo Faro enafiel Porto aredes Porto almela Setbal aos de Ferreira Porto lontijo Setbal latosinhos Porto laia Porto lafra Lisboa shna Lisboa 21 8 9 10 1 24 7 1 29 9 9 20 53 26 19 22 22 54 14 10 10 10 4 24 8 10 22 20 18 10 8 19 21 15 33 30 19 20 53 92 78 48 84