Find\Lookup sequence of numbers in rows

[webbooo]

Hello eveyone,


good to see the forum is back and operating. 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

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

 

[mathchick]

Hi there, Someone else might have more insight on this than me, but I'm fairly certain there isn't a way of doing this with formulas. Most likely VBA would be required for something like this.

 

[webbooo]

Hi there, Someone else might have more insight on this than me, but I'm fairly certain there isn't a way of doing this with formulas. Most likely VBA would be required for something like this.

Hi mathchick,

thanks for that, open to any VBA suggestions if anyone has any

cheers