Make Excel VLOOKUP Return the First Exact Match
Question details
Find the first exact match for a lookup value when the lookup column contains duplicates.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A spreadsheet contains repeated lookup values, and the user wants VLOOKUP to return the result from the first matching row.
- Observed behavior
- Approximate matching can return a different duplicate than expected; an exact match should return the first matching row from the top of the lookup range.
Identify the lookup value, the column containing possible matches, and the column containing the result. Make sure the lookup column is the leftmost column of the range used in VLOOKUP.
Use FALSE to return the first exact VLOOKUP match
Use exact matching when duplicate lookup values exist and you need the result from the first matching row.
With FALSE as the fourth argument, VLOOKUP searches the first column of the selected range from top to bottom and returns the first exact match. Exact matching does not require the lookup column to be sorted.
In Excel, click the cell where you want the lookup result to appear.
Type =VLOOKUP(A2,$D$2:$E$100,2,FALSE) and press Enter. This searches for A2 in D2:D100 and returns the value from column E on the first matching row.
Edit A2 and $D$2:$E$100 to match your worksheet. Change 2 if the desired return column is in a different position within the selected range.

Find the first exact VLOOKUP match in WPS Spreadsheets
Use the same VLOOKUP formula in WPS Spreadsheets to find the first exact match in a worksheet containing duplicate values.
- 1. Open your worksheet: Open WPS Spreadsheets and use Open to select your workbook.
- 2. Select a result cell: Click the cell where you want the first matching result to appear.
- 3. Enter the lookup formula: Type =VLOOKUP(A2,$D$2:$E$100,2,FALSE), adjust the references for your data, and press Enter.
- 4. Check and save: Confirm the result comes from the first matching row, then use File > Save to save the workbook.

Frequently Asked Questions
Does VLOOKUP return the first duplicate when I use FALSE?
Yes. With FALSE or 0 as the fourth argument, VLOOKUP searches the first column of the specified range from top to bottom and returns the result from the first exact match.
Why does my VLOOKUP return a different duplicate?
Check the fourth argument in the formula bar. TRUE or an omitted argument uses approximate matching. Change it to FALSE to return the first exact match.
Does the lookup column need to be sorted?
No sorting is required for VLOOKUP with FALSE. Approximate matching with TRUE or an omitted fourth argument requires the lookup column to be sorted in ascending order.
What if exact-match VLOOKUP returns #N/A?
Check that the lookup value appears in the leftmost column of the selected range. Also check for differences such as extra spaces or numbers stored as text.




