Function Problems

Find the First Excel Value Greater Than or Equal to a Target

Olivia MillerOlivia Miller Nov 12, 2026 870 views

Question details

Find the first value in an Excel range that is equal to or greater than a specified target value.

Find the First Excel Value Greater Than or Equal to a Target
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user needs an approximate lookup that returns the next matching value rather than the largest value in the range.
Observed behavior
The desired result is the first value greater than or equal to the target in an ascending sorted lookup range.
Before you start

Confirm that the lookup values in UKB!R11:R117 are numeric and sorted from smallest to largest. Also verify that the target cell, such as 'Beam Calculations'!I10, contains a comparable number.

Solution 1Recommended

Use XLOOKUP to return the next larger Excel value

Use this modern lookup formula when XLOOKUP is available and you want the returned value directly from the lookup range.

XLOOKUP match mode 1 returns an exact match or the next larger item when no exact match exists. Keep the lookup range in ascending order for predictable approximate-match results.

1
Select the result cell

Click the cell where you want the first value greater than or equal to the target to appear.

2
Enter the XLOOKUP formula

Type =XLOOKUP('Beam Calculations'!I10,UKB!R11:R117,UKB!R11:R117,"",1) and press Enter.

3
Check the lookup range order

Select UKB!R11:R117 and use Data > Sort Smallest to Largest if the values are not already in ascending order.

Use XLOOKUP to return the next larger Excel value
Next-larger match enabled: The final argument of 1 tells XLOOKUP to return an exact match or the next larger value.
Smart spreadsheet lookup tools

Find the Next Larger Value with WPS Spreadsheet XLOOKUP

WPS Spreadsheet lets you use XLOOKUP and XMATCH formulas to find an exact value or the next larger value in a sorted range. Open your workbook, enter the formula, and continue working with a familiar spreadsheet interface.

  1. 1. Open the workbook in WPS Spreadsheet: Launch WPS Office, choose Spreadsheets, and open the Excel workbook containing the target and lookup ranges.
  2. 2. Verify the lookup values are sorted: Select the lookup range, then choose Data > Sort and sort the values from smallest to largest.
  3. 3. Insert an XLOOKUP formula: Click the result cell and enter =XLOOKUP(target_cell,lookup_range,lookup_range,"",1).
  4. 4. Confirm the returned value: Press Enter and verify that the result is equal to the target or is the first available larger value.
Use XLOOKUP or XMATCH to return the first value greater than or equal to a target.Sort lookup ranges and manage formulas in a lightweight spreadsheet app.Open, edit, and save Microsoft Excel .xlsx and .xls files.Use a familiar worksheet layout for a smooth migration from Excel.
microsoft office alternative - wps office

Frequently Asked Questions

What does match mode 1 mean in XLOOKUP?

In XLOOKUP, a match mode of 1 returns an exact match when available; otherwise, it returns the next larger item in the lookup array.

Why should the lookup range be sorted from smallest to largest?

Ascending order ensures the range is organized for approximate matching and makes the returned next-larger value predictable. Select the range and use Data > Sort Smallest to Largest.

How can I return a related value from another Excel column?

Keep the same lookup range but change the return array. For example, use =XLOOKUP(A2,R11:R117,S11:S117,"",1) to find a value in column R and return the related value from column S.

What happens if the target is larger than every value in the range?

XLOOKUP cannot find a next larger value, so it returns the value supplied in its if_not_found argument. In the example formula, that argument is "", which returns a blank.

Can I use INDEX and XMATCH instead of XLOOKUP?

Yes. Use =INDEX(UKB!R11:R117,XMATCH('Beam Calculations'!I10,UKB!R11:R117,1)) to return the exact or next-larger value from the same range.