plz consider these facts 1 1 master data sheet is there with SL no,MCL NO and Name columns 2 The next "sheet2" has similar column of MCL no. 3 My need is :when the user fills a specific "MCL NO" corresponding name should be auto filled as provided in the "sheet1"
Use Vlookup for your query.
Have a look in the below links to know more about Vlookup.
http://www.contextures.com/xlfunctions02.html http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a-simple-tutorial-part-i/
Advertisement