Forum Discussion
Solved
Vlookup not selecting first cell from top.
Hi, I have a table with more than one match for the Lookup_value. If there are four matches, then the result returned is from the last match found and not the first. I've solved this be sorting...
See the attached version. It has VLOOKUP with FALSE as 4th argument and XLOOKUP.
If you are looking for an exact match, you should specify FALSE as 4th argument of VLOOKUP:
=VLOOKUP(lookup_value, lookup_range, column_index, FALSE)
This will return the value corresponding to the first match. If you have Microsoft 365 or Office 2021, you can use XLOOKUP - it provides more control over how Excel will search.
- Thanks Hans, I'll take a look. I've not used XLookup before.
Regards
Deon
