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.


--
Charleswdowd
------------------------------------------------------------------------
Charleswdowd's Profile: http://www.excelforum.com/member.php...o&userid=29017
View this thread: http://www.excelforum.com/showthread...hreadid=487493

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.

"Charleswdowd" wrote:


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.


--
Charleswdowd
------------------------------------------------------------------------
Charleswdowd's Profile: http://www.excelforum.com/member.php...o&userid=29017
View this thread: http://www.excelforum.com/showthread...hreadid=487493

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


Charleswdowd Wrote:
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.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=487493

Thank you Brian.


--
Charleswdowd
------------------------------------------------------------------------
Charleswdowd's Profile: http://www.excelforum.com/member.php...o&userid=29017
View this thread: http://www.excelforum.com/showthread...hreadid=487493

Good to see, and thanks for the response.

Charleswdowd Wrote:
Thank you Bryan.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=487493