Summary
This video looks at how to filter based on the lookup values from another table.
Tab in example file: Lookup tables
The example uses the XLOOKUP function to lookup the value from another table.
XLOOKUP – Searches a range or array for a value, if a matching value exists, it returns the corresponding value from another range or array.
The syntax of XLOOKUP is:
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])- lookup_value – The value to search for.
- lookup_array – The array or range to search in.
- return_array – The array of range to return the value from.
- [if_not_found], [match_mode], [search_mode] are not used in this example.