Forum Discussion
szub_2
Jan 23, 2020Copper Contributor
Number formatting Issue causing problem in V-lookup
Hello, I have cells that I am trying to compare in two worksheets to do a vlookup and I am not getting any results and I think it is because of the number formatting. The value in the cells are ...
SergeiBaklan
Jan 24, 2020Diamond Contributor
VLOOKUP doesn't care about formatting, it case only about data type - both lookup value and an array are to be the same type, numbers texts. Plus with numbers rounding in calculations or internal rounding (excel keeps only first 15 digits for the numbers).