Find\Lookup sequence of numbers in rows

Hello eveyone,


I have a query which has puzzled me but I'm hoping someone might have some ideas for.


Basically I'm trying to look up a series of numbers against a seperate row of numbers and look for a match regardless or number order.


for example

35hh3f4.jpg

If you look at the above picture I'm trying to do a query of some sort that will look up the numbers in A8:G8 in then search each row in the above table ie look for the numbers in B1:J1, B2:J2,B3:J3 etc I need to be able to search each row and look for the sequence of numbers regardless of order, if there is or inst a match for all numbers it should look at the next row and so on (maybe multiple matches). If there is a match then it should display the Name located in column "A" into cell G8. In this example to Jarrad row contains the numbers located in A8:G8. If there is no match it should display "None".

I'm trying to find any easy way to do this as I have over 500 rows I'm trying to query. The number's in A8:G8 in this example could also be more or less, ie here I have included 6 numbers but this could be 3 or 9 etc

Hopefully someone may have an idea, appreciate any assistance

Thanks

Alex

not sure if this can be done in a formula but would also appreciate any vba suggestions, thanks