If then function for mutiple cells

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:42 PM GMT

QuestionEdit

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"

AnswerEdit

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

©2024 eLuminary LLC. All rights reserved.