vlookup not working
I have two file test1 and book1, in book1, I vlookup in test, for example, 500016433 should get -1, but now it is not, how to change column M in book1, so we can get value from test?
test, book1 is as follows
if I manually put value 500016433 in the vlookup, it is working, so i guess I need to change colmn M format, but how to change, I have around 2000 records, I don't want to change one by one
|