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