Lookup - text and numbers

Giganews Newsgroups
Subject: Lookup - text and numbers
Posted by:  Annette (shed…@hotmail.com)
Date: Tue, 1 Jul 2008

I have a table that formally contained only numbers, now we have one number
with text characters throwing off my formula for return values.  This is the
current formula -


Is there a way to change this to recognize there could be text and numbers
or do I have to change the tables to be all text?