Hi,
I'm creating a template for a reconcilliation.
The following problem occurs:
Sheet 1 has a VLOOKUP which searches numbers in the range 100000-999999 in sheet 2.
Sheet 2 has a range (A:A) with numbers 1-999999.
Number 1 in sheet 2 should be 100001, number 2 should be 100002, and so on.
So at the end of sheet 2 i added the formula =text(A2,100000) so the format will be 1XXXXXX.
The problem is now that the VLOOKUP in sheet 1 does not work and will result in #N/A and that is offcourse because the formula i used in sheet 2 does not make a value.
Now without copy & Pasting this as values, is there a script i can use that automatically transfers the numbers to this format?
The collumn where i put the formula now is V.
Thanks for your help and advice.
Regards,
Crispy85
Bookmarks