Function Problems

Make Excel VLOOKUP Return the First Exact Match

Rana GarciaRana Garcia Nov 18, 2026 868 views

Question details

Find the first exact match for a lookup value when the lookup column contains duplicates.

Make Excel VLOOKUP Return the First Exact Match
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the result cell

In Excel, click the cell where you want the lookup result to appear.

2
Enter the formula

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.

3
Adjust the references

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.

Use FALSE to return the first exact VLOOKUP match
Avoid approximate matching: TRUE, or an omitted fourth argument, uses approximate matching and requires the lookup column to be sorted in ascending order. It may return a different row than the first exact match.
WPS Spreadsheets

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. 1. Open your worksheet: Open WPS Spreadsheets and use Open to select your workbook.
  2. 2. Select a result cell: Click the cell where you want the first matching result to appear.
  3. 3. Enter the lookup formula: Type =VLOOKUP(A2,$D$2:$E$100,2,FALSE), adjust the references for your data, and press Enter.
  4. 4. Check and save: Confirm the result comes from the first matching row, then use File > Save to save the workbook.
Return the first matching row with FALSE in VLOOKUPOpen and edit Microsoft Excel XLSX and XLS filesWork with formulas in a familiar spreadsheet interface
microsoft office alternative - wps office

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.