When VLOOKUP is not working because of numbers stored as text

If you want to store data with leading zero (Format cell-> Special) - you will have problems with LOOKUP formulas because of "The number in this cell is formatted as text or preceded by an apostrophe". The simplest solution is to multiply search range with 1.

Example:
=VLOOKUP($A$2:$A$718*1;Sheet2!$A$3:$B$725;2;FALSE)