Find the position of an item in a range. Normally an INDEX MATCH formula is configured with MATCH set to look through a one-column range and provide a match based on given criteria. In the example above I used a 4 for the row_num argument for INDEX.
INDEX A1B522 returns value in B2 INDEX A1B531 returns value in A3.
INDEX data_array MATCH vlookup_value lookup_column_range 0 MATCH hlookup value lookup_row_range 0. To write the formula combining the two we use the MATCH function to for the row_num argument. How to use INDEX and MATCH The INDEX Function. Match function will return the index of the lookup value in the header field.