woorkbookA.xlsm
and
woorkbookB.xlsm
The contents/number in column J of woorkbookA has to be checked with column S of woorkbookB.
If the contents/number in column J exists in column S of woorkbookB, I want it to be marked with an X in column U of workbookB.
I've been trying to get this to work, I've gotten some help from others but I'm stuck with this piece of code:
=IF(ISERROR(MATCH(S2;[woorkbookA.xlsm]Blad1!$J$1:$J$13;0));"";"x")
But I keep getting #NAME? errors when putting in the formula in U2.
I've been told it could be regional differences since I use Swedish settings.
I appreciate any help! I'm quite the newbie with excel.
Bookmarks