Dear Mukesh, The problem indicated by you can be resolved by using VLOOKUP function in Excel. VLOOKUP function is a short form for Vertical Lookup. This function searches alphabetically in a database.
You can therefore do the following: 1. Create a worksheet called "Master List" or any other name desired by you. You can then input district names in column No. A and their corresponding Abbreviations or Codes in Column B. Remember to sort this alphabetically as VLOOKUP function will not work if the database is not sorted alphabetically. 2. Once the above database / Master List is ready then use VLOOKUP in your working sheet and provide reference to the above created list. 3. VLOOKUP function is not a very straight forward function and requires some hands on practice before using it in making worksheet. MS Excel built-in help can be used for the syntax of this function. Please write back in case of further issues. Hope that helps. Regards, Vivek Singhal, ________________________________ My E-mail Address has changed. Kindly use "singha...@indianoil.in" This Message was sent from Indian Oil Messaging Gateway, India. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. ________________________________ Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
