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

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

Try:

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