hi
I attached a file. numbers in sheet 2 will be checked if they are in sheet one.
it is not important to have same format, it is enugh to find correct number in the searched sheet 1. if found, it will write ok next to each cell in sheet one.
for example I want to search 0532 612 23 61 in sheet 2 in sheet 1, if it is in cell A2 in sheet 1 ( A2 value 905326122361 or 05326122361 ) it will write OK. so it is a character comparing, can it be with a formula or code.