Spreadsheets | VLOOKUP vs INDEX MATCH

// http://www.mbaexcel.com/excel/why-index-match-is-better-than-vlookup/

// https://www.vertex42.com/blog/excel-formulas/vlookup-and-index-match-examples.html#simple-examples

=INDEX(result_range,MATCH(lookup_value,lookup_range,0))

How it works: The MATCH function returns the position number 3 because "a_003" matches the 3rd row in the Item ID range. Next, INDEX(result_range,3) returns the 3rd value in the price list range.

// Cheat:
=INDEX ( Column I want a return value from , MATCH ( My Lookup Value , Column I want to Lookup against , Enter “0” ))
// http://www.randomwok.com/excel/how-to-use-index-match/