Hello, I have the following data table which I'm trying to look up to:
Code COY1 COY2
1 Keep Keep
2 Reject Keep
3 Reject Reject
4 Keep Reject
For example, I want to find the result if Code =1 and Company = Coy2
I have used the following formula but it only works if I change the data in...