VBA / Office Searching for Duplicate Codes with XLOOKUP in Excel: How to Choose Between First and Last Matches
Verification status: Specification checked (spec_checked). The specification has been verified against official documentation. Execution of the formula examples has not been verified. In tables where product codes or employee codes appear across multiple rows, the values returned for the same search value may differ between the first and last rows. By default, XLOOKUP scans from the beginning of the search range and returns the first match found. To get the match at the end,