Formula Help

Occasional Visitor

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...

Excel.PNG

1 Reply

@ashmah1600 

As variant

=XLOOKUP($A2&B$1,$I:$I&$J:$J,$K:$K, "no such")