The formula working by using ampersand operator (&) that joins the criteria-values that will be looked up in a range combined in a similar fashion. The result will be used to fetch back the results from the required range of cells.
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