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