dear Ronsmithcan,
use below formula
=VLOOKUP(CLEAN(SUBSTITUTE(B3,CHAR(160),CHAR(17))),E:F,2,FALSE)
Regards,
Gawli Anil
On Sun, May 22, 2016 at 4:21 PM, Bill Q wrote:
> Hi,
>
> PSA.
>
> Trying to do a simple vlookup. I cleaned up the data by trimming, but
> still cannot get a match.
>
> I manua
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 data by trimming, but
> st
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 =NOT(EXP
