match an a string of numbers in a table and return value

I have a set of 6 numbers in A1:A6 (example 10,20,30,40,50,60). I'm trying to match the 6 numbers against a table 6x300ish and return a value of the matching row in the table. The first 6 columns are numbers the I need to lookup and the last column is the reference number 1 to 5 in example

table example

11,20,30,40,50,60,1
12,20,30,40,50,60,2
13,20,30,40,50,60,3
14,20,30,40,50,60,4
15,20,30,40,50,60,5

please provide the data in excel sheet with sample solution

how do i attach a file or do you mean attach image

Hi

See if this helps you

A$1:A$6 are the numbers to search
$A$21:$ZZ$21 is a table 6 x ...

Use and copy forward for other columns

Formula:

Please Login or Register  to view this content.

see the file

I have uploaded a file as requested and the file contains before and after. hope this helps


the pattern combination contain 210 possibilities and every event produces a list of 6 numbers, I need to know what pattern the 6 numbers are equal to.

cheers

Try this

Formula:

Please Login or Register  to view this content.

Note: Date after not correct?

see the file

awesome news it works, thank you.

Just one more thing, how would i go about solving this problem using VBA. Im not looking for a solution just some advise, so I can investigate.

Hi
You are welcome.

You can post the question in this forum under the group
Excel Programming / VBA / Macros (Post any VBA, Macros, Add-Ins questions here).

Do not forget to mark this thread as solved (use Thread Tools located above your first post and choose "Mark this thread as solved"