How To Activate TuneTalk Prepaid SIM Card

Kindly send sms type BEL and send to 2222. The plan will be:

• Plan Includes: 300MB Data + 30mins Local Calls + 30 SMS. 1st Month FREE

For further inquiry, kindly contact us at 0379490000 or 13100.

Lookup Value Using INDEX-MATCH Function in Excel

Index-Match function in excel is useful if you want to cross-checking between two tables.

How to use it:
INDEX(columnArrayThatHasTheValueYouWantToReturn, MATCH(lookupThisValue, columnYouWantToLookupAgainst))

In below example, you can see I want to lookup the item code and what is the remaining quantity left for Stamp. Next to the result, is the formula (don't forget to put "=" infront of the text in formula though).

Hint:
#1: You can also lookup between different sheet/table. Just navigate to your other sheet and excel should replace the array with the sheet you're refering to.

#2: If you copy the result cell to another cell, most likely excel will increment/decrement the cell coordinate in formula. To lock this, apply $ sign to the cell coordinate in formula.
eg: B2:B6, to lock this so it won't change, apply dollar sign
    $B$2:$B$6 - select the coordinate, press F4