Invisible Characters Cause Excel Vlookup Failure Jun 19th, 2014 • Permalink After 30 minutes to solve invisible char cause Excel vlookup failed, I find below fomula is useful: VLOOKUP formula that ignores trailing invisible charactersCopy=VLOOKUP(I2&"*",Sheet2!C:C,1,0)