Question: I'm using map box SDK on my android application. Total apk size will be 24MB.

How to reduce that size?

Please give solutions

```
compile('com.mapbox.mapboxsdk:mapbox-android-sdk:5.0.2@aar') {
    transitive = true
}

```

Answer: 
You can use the following formula to return what you're looking for. It is an array formula so will need to be entered with `Ctrl`+`Shift`+`Enter`

```
=INDEX(Sheet2!$C$2:$C$22; MATCH(1; (Sheet2!$A$2:$A$22=Sheet1!$A2)*(Sheet2!$B$2:$B$22=Sheet1!$B2);0))

```

As it is an array formula I recommend defining your ranges from beginning to end instead of just selecting the whole column. Non-array formulas Excel actively finds the beginning and end of the range and only calculates that subset; however, with array formulas it considers the whole range (even if there's nothing in it) so it can suddenly take a very long time even when there isn't much being calculated
Paste this into cell `C2`:

```
=INDEX(C2:C22,MATCH(G2&H2,A2:A22&B2:B22,0))

```

and use `Ctrl`+`Shift`+`Enter` instead of `Enter` since it's an array formula. 

Then copy that cell as many rows down as needed.

Here are some [more examples](http://www.excel-easy.com/examples/two-column-lookup.html).