vb6 - Matching specific items in several discrete collections -

i have problem whereby have several discrete lists of id's eg.

list (a) 1,2,3,4,5,7,8
list (b) 2,3,4,5
list (c) 4,2,8,9,1
etc...

i have collection of id's...
example: 1,2,4

i need try , match 1 each list. if can match id's in secondary collection (one collection id matched id each list) true result....

i have found becomes complicated because if iterate on lists matching first collection/list pair encounter may result in precluding possible combination further on down line hence returning false negative result.

for example:

list (a) 1,2,3,4
list (b) 1,2,3,4
list (c) 3,4

collection is: 3,1,2

the first id collection (3) matches entry in list a, second id in collection (1) matches item in list b, final id in collection (2) doesnt match entry in list c if rearrange order of collection be: 2,1,3 match found.... therefore looking form of logic attempting match on possible combinations in efficient manner(?)

to make more complicated id's guid's cant sorted in ascending order

i hope have described enough make clear attempting , bit of luck able tell me need easy , missing real simple!
forced code in vb6 methods or pseudo code great. backend of sql server if solution using tsql possible better of id's held in tables already.

many in advance.

jake, yep lists , collection both contain guids. used plain integers simplify problem bit.

once list has been matched cant searched again, hence ordering problem tried explain. if list 'matched' no further attempts match performed. behaviour can cause false negative.

'sending' collection in in every possible combination of orders work massive job .....

i feel must missing straightforward concept or solution here??!!
assistance far.