I need to get the 2nd result of the list of same order nos

[DPM_reports]

Hi,

I want to pull data from a table where I have multiple order id …each with a unique id in a separate row, here I want to pull the 2nd or 3rd result of that order id.

Here in the screenshot u can see that in the 2nd column I have repeated order nos…I want to pull the value of this order number with the result being the value in the 3rd column of the corresponding order id

[Steve · Accepted solution]

Try:

LOOKUP(
  INDEX(
    ORDERBY(
      FILTER(
        "Table",
        ([_THISROW].[Order Id] = [Order Id])
      ),
      "_ROWNUMBER"
    ),
    2
  ),
  "Table",
  "KeyColumn",
  "Product Id"
)