I have been trying to Google to find what formula I need for the last hour with no help, hoepfully someone here can help me. I think I am looking for something along the lines of if array contains cell a and cell b return value c?
So if A2 is found in range I AND B1 is found in range J, input K?
If A2 is found in range I AND C1 is found in range J, input K?
And so on...
