It is work as well .. really thanks for help
flummi Wrote:
Suppose your account no. is in A1, try this:

=vlookup(value(a1),<range,......

Hans


--
achilles
------------------------------------------------------------------------
achilles's Profile: http://www.excelforum.com/member.php...o&userid=31210
View this thread: http://www.excelforum.com/showthread...hreadid=508827