I am using this formula
to lookup the values for the empty column I on sheet 1, which are present on sheet 2 although in a different order and
sometimes even non-existant.
Here is the problem:
I have, for testing purpose, a file with 2 identical sheets, only difference is that I deleted all numbers from column I on
sheet 1, but all the values are present in column I on sheet 2.
Each value in column is categorized by a unique number in column E, thus this is the way to find out the correct value for
the listed unique number.
Now, when I insert this formula in sheet 1 column I, It looks through sheet 2 and gets me to correct the value for each
unique number. And here is the kicker: the total SUM of that generated number is different than from the original (and 100%
correct) total I have on sheet 2.
This formula works fine on my dummy sheet with 10 rows, but it does not in my
actual workbook with 2000 rows...