Re: $$Excel-Macros$$ Vlookup Matching Issue

Hi, in lookup value, at end " " is available. to clear this use the following formula =CLEAN(SUBSTITUTE(B3,CHAR(160),CHAR(17))) Regards, A Gowrisankar ​ On Sun, May 22, 2016 at 4:21 PM, Bill Q wrote: > Hi, > > PSA. > > Trying to do a simple vlookup. I cleaned up the

$$Excel-Macros$$ Vlookup Matching Issue

Hi, PSA. Trying to do a simple vlookup. I cleaned up the data by trimming, but still cannot get a match. I manually entered in data in B2 in order to get a match. I never encountered anything like this before. Not certain how to fix. Anyone ? Thanks. -- Are you =EXP(E:RT) or