lookup an array in a row in a index and return a value if array matches any row in index

In the attached I have used numbers to illustrate what I want. in the first row I have 1 2 3 4 (A1~D1), starting in F1~I3 I have created a simple index, and at the end of those rows i have a corresponding number to indicate the value of each indexed row. What I want to do here is compare A1, A2, A3, A4 to F1:I3 index, if the numbers in A1~A4 macth exactly any row the value in M1:M3 should return in J1. This is waht I have tried.
=IF(AND(A1=F1,B1=G1,C1=H1,D1=I1),M1,"")&IF(AND(A1=F2,B1=G2,C1=H2,D1=I2),M2,"")&IF(AND(A1=F3,B1=G3,C1=H3,D1=I3),M3,"")
This works, but I have 100's of number configurations in my index and it becomes too cumbersome to create the formula and excel runs of formula availability before all is entered.
i would like to do this same function in VBA but with a 1000 row index referenced.
Can someone help me with this?

Thank you

Plrod

I tried but after entering it as shown above it return an N/A (with 1234in cel abcd) and a div by o error if any other numbers are entered into abcd

Formula works OK for me with your supplied sample file - 5000 was placed in J1.

Error conditions can be "removed" by using

=IFERROR(LOOKUP(2,1/($F$1:$F$3=A1)/($G$1:$G$3=B1)/($H$1:$H$3=C1)/($I$1:$I$3=D1),$M$1:$M$3),"")

Entering 5,6,7,8 in A1 to A4 resulted in blank using the above.

If you used a different set of data, please post here.

Great! that works! Many thanks!

If the problem is fixed, could you please mark the thread as SOLVED ("Thread Tools" at top of first post). Thank you.