Lookup/match in multiple columns meeting criteria

I have a very large database (4 separate columns) with between 400,000 and 600,000 rows and I need to lookup a registration number in each one and if 2 or more events happened on the same date then return 1 as 'meeting criteria.'

I made an example sheet with the expected output. Column Q has the Lookup value and R has the expected output. So basically, the number in Q should be looked up in A, E, I, and M and then if the MEAS_DATE is the same and MEETS_CRITERIA =1 in 2 or more columns, then the output should be 1.

I have tried to figure out a way to do this with what knowledge I have of excel but am struggling to figure out how do this. any help would be appreciated.

Example_factors.xlsx

Let me try to give a better explanation. The code you wrote will indeed check for more than 1 number in the row. The problem is that each of the 4 columns of information are not always lined up exactly with the same 'person' in each row.

So "Factor A_REG_NO", "Factor B_REG_NO", etc are people who have had this Factor checked on them on a particular date. Not everyone will have had the factor checked; therefore, the rows won't line up exactly across all 4 columns. Thats why I was trying to use the "master list" of "REG_NO" called "LOOK-UP REG NO" to go through each column of data, and then find whether a factor was checked on the same day. If so, then if any 2 of Factor A, B, C, or D are equal to 1, to return in the output a 1.

What I am imagining happening is the following: for Lookup-REG NO 127086579, it starts in column A and finds 3 occurences of the Lookup-reg no, these are on 1/15/2008, 1/16/2008, and they each 'Meet criteria" meaning they have a 1 in column C. The code should then look into column E and find the same lookup-reg no and it would find a number of occurences, none of them have a 1 on any day that column C had. When the code then looks into the factor C columns, it will find a 1 occuring also on 1/16/2008;therefor the output should be 1.

Hope that is understandable.

If this is not possible to do in Excel, I also can try and use other software if people have suggestions.

Yeah the dates have to match. For each REG_NO, if any 2 Factors_meet criteria on the same day, then the output should be 1.

And it could be any of the dates in the 4 columns of information.

What code are you using for the matching on reg and date? One thing I could do is remove all the people with a 0 for "meeting factor" since those don't matter. Then I could just match on Reg NO and date and if two or more match then the output would be 1).