I have one table (1) in sheet 1 and another table (2) in sheet 2. I want a formula in sheet 3 that checks if values in table 2 exists in table 1, if no, then the formula should return the missing value.
I tried but do only get N/A#. Lookup value found when evaluating the formula but in the next step error. Does have to do with the values in the array being numbers generated by formulas referring to an additional sheet?
Please see picture. It does not even work on the same sheet. All cells are formatted the same and there are no space or such things. J column= left and L= right, just noticed I did not capture that part on the pic.
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..