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
