[Excel][INDEX/MATCH]How to use INDEX MATCH function in Excel

=INDEX (column to return a value from, (MATCH (lookup value, column to lookup against, 0))






reference: https://www.ablebits.com/office-addins-blog/2014/08/13/excel-index-match-function-vlookup/