Hi all,
I am wrapping my head around this, for a while. I am trying to compare, based on ID, two sheets, as there was some changes (human error) and some of IDs have the wrong size.
As an example, the ID 12345 has the size 45 in sheet 1, and the same ID has the size 42 in the other sheet. I would kindly ask you to help me highlight only the same ID's that have different values. Xlookup is not working as the rows are not the same and Vlookup is returning true until ro 26 (?) and after that false till the end.
The file is here: Product import.xlsx
Many thanks in advance,
O.
I am wrapping my head around this, for a while. I am trying to compare, based on ID, two sheets, as there was some changes (human error) and some of IDs have the wrong size.
As an example, the ID 12345 has the size 45 in sheet 1, and the same ID has the size 42 in the other sheet. I would kindly ask you to help me highlight only the same ID's that have different values. Xlookup is not working as the rows are not the same and Vlookup is returning true until ro 26 (?) and after that false till the end.
The file is here: Product import.xlsx
Many thanks in advance,
O.