You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004

In article ,
says...
Tushar,

Thank you for the solution (and an excellent explaination).

Interesting to note that if I do the CDbl conversion in the assignment statement instead of the VLookup function call it still returns a type conversion. The conversion has to be done in the function call.

Thanks again.