Objective:
- Compare and combine data on two different spreadsheets.
- Looking up a value in a column or row, and return a cell from the corresponding row or column
Environment:
- Microsoft Excel
Additional Information:
Procedure:
- Syntax: =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
- Input lookup_value, the value you want to look up
- Input lookup_array, the column or row you want the lookup_value to be found in
- Input return_array, the column or row you want the corresponding cell to be returned from
- Optional: Input value if no results found
- Optional: Specify match type, exact match is by default
- Optional: Specify the order to search from