Lookup formulas: Must manuly type in look up value over downloaded value

[Charleswdowd]

I work with alphannumeric codes that I often need to lookup up with v
and H lookups. However, many times I will get an error. When I do get
an error it is corrected when I re-type the same code manualy in the
cell being looked up. I also get this error with numeric codes but
usuly the "Value" function nested with the lookup function makes
everything work. Is there a way to acomplish the same thing but with
text codes.

 

[Guest]

I'm not entirely clear on the circumstances causing the current issue: what
value you are you looking up, and what's the apparent equivalent in your
table. In my experience, I've often used the VALUE function as you suggest
inside the lookup to force text data to match up against a table of numbers.
To get numeric data to match against a table of strings I typically use the
TRIM function, just as you're using value now. BTW, trim also addresses a
fairly common issue of trailing spaces.
HTH. If not, please do indicate the current issue and a detailed example.

 

[Bryan Hessey]

If the lookup failed because of a trailing space (=Len(A1) would show
that) then =Trim(A1) might help.

 

[Charleswdowd]

Thank you Brian.

 

[Bryan Hessey]

Good to see, and thanks for the response.

Thank you Bryan