Look up data.. help please :-)

[jhong]

Hi,


Here's the scenario, my data is like 088111 while the file given to me
omits the zero 88111, how can I make a look up where I can still get
the same result even if the reference data and source file is
different. Is it possible?


Thanks in advance!


Jhong

 

[Joel]

If you have dat like 088111 (with zero in front) then it must be string data
while the number with out the leading zero is really a number. You can
convert the 088111 to a number by using the val function val(088111).

I suspect the is a single quote infront of the 088111 which is making it a
string. To remove the single quote use

val(mid("'088111",2))