Hi Ronny
Looking at your code you are searching in columns A to Z but you are only returning the value in Column 2 of the search range if the value in VLOOKUP is found. On that basis you only need to search between columns A and B. This may be why you are getting the error.
Hope this helps.
Good luck.
Tony