Hello Vivek, I have solved my problem by using 'if' function. But I would like to learn 'look up' function from you tomorrow. Please illustrate it using following information for me. column a column b name of districts abbreviations Ahmednagar: AH Akola: AK Amravati: AM Aurangabad: AU Beed: BE Bhandara: BH Nashik: NSK Pune: PU Latur: L
These are some abbreviations of districts. Please send me a excel file as attachment illustrating the 'look up' function at the earliest. Please also let me know how to avoide duplicate entry from the database in excel. I know the remove duplicate function but instead of removing it manually later I want to prevent duplicate entry while entering the data. Thank you. Regards Mukesh Baviskar Mobile: 9403161157 From: Singhal, Vivek Sent: Saturday, September 22, 2012 11:58 AM To: 'accessindia@accessindia.org.in' Cc: 'mukeshbaviskar....@gmail.com' Subject: Excel formula 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
