The MATCH() formula uses ampersand operator (&) to connect the criteria. The respective ranges are also combined using this ampersand sign. The number that is retrieved is used to feed to the second argument of INDEX and thus we retrieve the value.
Category: Lookup and reference
Uses an index to choose a value from a reference or array
INDEX(array, row_num, [column_num])
Looks up values in a reference or array
MATCH(lookup_value, lookup_array, [match_type])
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM