Forum Discussion
Solved
Help with creating new list off another list
Trying to pull the Delivery # for all the Customers in the list in Column J This formula doesnt appear to be working in any fashion, tried a few others and i'm not making any progress. =UNIQUE...
Use IFERROR:
=IFERROR(CHOOSECOLS(FILTER('OB Summary'!B2:Z1000, BYROW('OB Summary'!L2:L1000, LAMBDA(r, OR(ISNUMBER(XMATCH($J$1:$J$11&"*", r, 2)))))), 1, 2, 4, 11, 14, 6, 8, 20), "")
Last thing, in the event there's no return, to avoid a CALC error I tried throwing a =IF(ISNUMBER(ROWS(filtered),"No Records")) at the end but not making progress.
Use IFERROR:
=IFERROR(CHOOSECOLS(FILTER('OB Summary'!B2:Z1000, BYROW('OB Summary'!L2:L1000, LAMBDA(r, OR(ISNUMBER(XMATCH($J$1:$J$11&"*", r, 2)))))), 1, 2, 4, 11, 14, 6, 8, 20), "")
- Of course! Thank you!