1 Select Office Database
2 Office Data Array
XLOOKUP allows you to search any column to find your target.
3 Extraction Logic
=XLOOKUP(lookup_value, lookup_column, return_column, "Not Found")
Data Practice Lab
XLOOKUP allows you to search any column to find your target.