I have a problem. I have two codes for the same stock. e.g. 1)AUROPHARMA and
2)AUROPHARM.NS.
there are subtle differences. The stock list in one case in code 1 is about
500. the other list is my stocks in code 2. now how to get both the
corresponding codes in two adjacent columns, provided it can at all be done.
.. When i tried with
vlookup(lookupvalue, database,columnno,true) to get approximate values i get
"ATUL". instead of auroph.......

I am familiar with vba and excel. Kindly advise me how to go about provided
this can be done

Mine is excel 2000


--
remove $$$ from email addresss to send email