Checking both columnns

[kjb14]

Hey, I am using the index match formula to check for two values that are in column A and B in the same row, and then it gives me the value that is in column I.

I am using the following formula:

INDEX($I$2:$I$200,MATCH(Y2&$W$3,$A$2:$A$200&$B$2:$B$200,0))

This works great when the text I am looking for in Y2 is in column A, and the text I am looking for in W3 is in column B. The problem is that I am doing this over and over again and the values are randomly in A or B.

So, I essentially need to run this formula twice. Once the way it is written, and once with Y2 looking in column B and W3 looking in column A.

Does anyone know how to do this?

Thanks in advance.

 

[Peter_SSs]

Try this, still confirmed with Ctrl+Shift+enter
=INDEX($I$2:$I$200,IFERROR(MATCH(Y2&$W$3,$A$2:$A$200&$B$2:$B$200,0),MATCH($W$3&Y2,$A$2:$A$200&$B$2:$B$200,0)))