Sorry, i was away for some time. I have figured it out. The file i have attached here was example of the original with some data. In the end i got a function like that:

=INDEX(data!$F$2:$P$60041; MATCH(AK5&AL5;data!$F$2:$F$60041&data!$G$2:$G$60041;0);11)

Quote Originally Posted by Spencer101 View Post
That doesn't mean it's not working. Just means that all the matches required are not met.

As I pointed out, one of the conditions in your original post (1. Check if AK(Sheet1) = F(Sheet2) if match) is not a match, so the blank cell is correct. If these two cells DID match then BE1 would not show as blank.