The most popular way to do a two-way lookup in Excel is by using INDEX MATCH MATCH. Working one step at a time lets leave the column hardcoded as 2 and make the row number dynamic. Formulas are the key to getting things done in Excel.
In this accelerated training youll learn how to use formulas to manipulate text work with dates and times lookup values with VLOOKUP and INDEX MATCH count and sum with criteria dynamically rank values and create dynamic ranges.
A A 0 and returns 1. Match function will return the index of the lookup value in the header field. INDEX data_array MATCH vlookup_value lookup_column_range 0 MATCH hlookup value lookup_row_range 0. Working one step at a time lets leave the column hardcoded as 2 and make the row number dynamic.