I entered a new variable with Concat, and used this with the function Match(). Please look at your QVW.
Greetings from Munich
TestQV.qvw 156.0 K
I couldn't get it to work. Try pasting in the following values:
It should return the first two values because they are valid, but the red box should appear and say: "Shipment ID(s) Not Found: 100". I'm not sure this is even possible, but you may be on the right track with match. Thanks!
If the number of shipments in the list can be limited, you could replicate the same formula for a number of components, using function subfield()... It's hard to do anything so complex that could check any number of components, without running a loop... The perfect solution can be developed using a macro, but then you are running into all the disadvantages of the macros...