Appreciate you trying. I created a new workbook, then I typed some random info in random tables and created 3 tables, to simulate the real problem. I used some index and match and it worked, when applying the same solution to the workbook to be used it does not work so I guess it has something to do with the the workbook and not formulas. I'll try to figure it out. I believe the issue might be caused because the numbers are not considered in numbers in one of the sheets..