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
Solved! Go to Solution.
Try:
LOOKUP(
INDEX(
ORDERBY(
FILTER(
"Table",
([_THISROW].[Order Id] = [Order Id])
),
"_ROWNUMBER"
),
2
),
"Table",
"KeyColumn",
"Product Id"
)
Try:
LOOKUP(
INDEX(
ORDERBY(
FILTER(
"Table",
([_THISROW].[Order Id] = [Order Id])
),
"_ROWNUMBER"
),
2
),
"Table",
"KeyColumn",
"Product Id"
)
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |