Sometimes you need to grab the next row after a criteria match in Google Sheets—for example, to pull the details that follow a certain label or category.

Sounds simple, right? Well… it’s not always straightforward — especially if your data isn’t in a neat “database” style layout.

Why This Problem Happens

When your sheet is perfectly structured, filtering is easy.

Example: Properly arranged data

Here, you can just filter the value column for supply or purchase and you’re done.

But sometimes, your sheet looks more like this:

Example: Improperly arranged data

Now things get messy. Your “value” isn’t on the same row as your “desc” — it’s on the next row down. A regular filter won’t work here.

A Real-World Example

Here’s a billing break-up table. Each item (like “Cable” or “Panels”) has several activities, each with a percentage of payment to be released.

Goal: Find the Installation percentage for Panels.

So:

• Criteria row = Panels
• Target row = the next row (Installation)

The Formula That Does It

Let’s say your data is in A1:C.

Here’s how you can grab the row right after your match:

=LET(
   cr, FILTER(ROW(A1:A), A1:A="Panels"),
   nr, {cr+1},
   FILTER(C1:C, XMATCH(ROW(A1:A), nr))
)

Breaking It Down

• cr → FILTER(ROW(A1:A), A1:A="Panels")
  Finds the row number where Panels appears.
• nr → {cr+1}
  Adds 1 to that row number to get the next row.
• FILTER(C1:C, XMATCH(ROW(A1:A), nr))
  Looks up that next row number and pulls the value from column C.

What If You Want More Rows?

Want the next two rows instead of one? Just tweak the {cr+1} part like this:

=LET(
   cr, FILTER(ROW(A1:A), A1:A="Panels"),
   nr, {cr+1; cr+2},
   FILTER(C1:C, XMATCH(ROW(A1:A), nr))
)

That {cr+1; cr+2} means “give me the row after and the one after that.”

You can keep adding more if needed.

What If the Criteria Appears More Than Once?

If you want to filter the next row after a criteria match in Google Sheets only for the first occurrence, simply stick with the formula above.

If you want the next row for all rows matching the filter criteria, you just need to make one change:

Wrap {cr+1} (next row) or {cr+1; cr+2} (next two rows) with the ARRAYFORMULA function, like this:

ARRAYFORMULA({cr+1})

or

ARRAYFORMULA({cr+1; cr+2})

Why Not Just Use OFFSET?

OFFSET can do something similar, but this LET + FILTER + XMATCH approach is:

• Dynamic — no hardcoded row numbers
• Stable — won’t break when you add/remove rows
• Readable — easier to follow than a long OFFSET formula
• Flexible with multiple matches — easily adapts to return rows after every matching criteria, not just the first one

Related Guides

• How to Offset Match Using QUERY in Google Sheets
• Offset VLOOKUP Results to the Correct Header Columns in Google Sheets
• XLOOKUP and Offset Results in Google Sheets
• Excel OFFSET-XLOOKUP: Better Alternative to OFFSET-MATCH
• Using OFFSET and MATCH Together in Google Sheets: Advanced Tips
• VLOOKUP Plus Next N Rows in Google Sheets – Return Multiple Rows
• How to Highlight Next N Working Days in Google Sheets
• Fill Blank Cells with the Next Non-Empty Value in Google Sheets