Number formatting Issue causing problem in V-lookup

[szub_2]

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 all numbers and quite lengthy.  Below are what some numbers look like. The cells have the green triangle in the left corner and if I click to convert to a number, it displays like row 3.  Normally if I convert to a number, then I get data from my vlookup, but with numbers this long, it does not work and I need the number to stay in tact. 

1204235000258

1404213090451

1.40421E+12

1501230000399

1502213090474

1504213091705

1504213091705

Appreciate any help.

Thank you

[#2]

Hello,

Kindly upload a sample file for better clarification

[#3]

@szub_2 

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).