Can EXCEL do this? Look for every row in this 4-column array, [example row 122456, ABCD, 54321, 7000] in a 2nd array that is also 4 columns but has many hundreds more rows, and every single time you find that exact combination in that exact order in a row in the 2nd array, return "Allowed," otherwise, return "NotAllowed" Thanks!
A Sample worksheet with mocked up solution would be very helpful here. The worksheet should probably not have more than 20 records. No pictures as we can not manipulate data in a picture.
Please see the attached example. If contains two solutions. One that works in modern Excel using the BYROW function in K1, spilling the results in one go. The other should work in all versions using SUMPRODUCT in M1 and copied down.
