Tips in Using Vlookup in Excel | 31 Best of Exceltitle> <meta http-equiv="Description" content="Using vlookups is very nice to use. It helps you do things which normally took alot of time to do" /> <meta http-equiv="Keywords" content="in excel,excel or,excel and,excel how to,how to excel,to excel,what is excel,what is powerpoint,what is a spreadsheet,what is spreadsheet,excel 2007,excel template,microsoft excel,what is microsoft excel," /> <link href="../style.css" type="text/css" rel="stylesheet"> </head> <body > <script language="JavaScript1.2"> //Disable select-text script (IE4+, NS6+)- By Andy Scott //Exclusive permission granted to Dynamic Drive to feature script //Visit http://www.dynamicdrive.com for this script function disableselect(e){ return false } function reEnable(){ return true } //if IE4+ document.onselectstart=new Function ("return false") //if NS6 if (window.sidebar){ document.onmousedown=disableselect document.onclick=reEnable } </script> <table cellpadding="1" cellspacing="1" width="800" align="center" bgcolor="#f2f2f2"> <tr> <td align="right" colspan="2"><img src="../images/banner_01.jpg" alt="training on microsoft excel" border="0" /></td> </tr> <tr height="57"> <td align="left" class="nav" colspan="2" background="../images/banner_02.jpg" style="padding-left:10px"> <strong> <a href="../index.php" class="nav">Home</a> - <a href="../contactus.php" class="nav">Contact Us</a> - <a href="../excel-courses-sitemap.html" class="nav">Courses</a> - <a href="../Learn-excel-online-for-free.php" class="nav">Learn online free</a> - <a href="../Assessment.php" class="nav">Assessment</a> - <a href="../manuals.php" class="nav"><a href="../manuals.php">Excel manuals</a> - <a href="../sitemap.php" class="nav">Sitemap</a> - <a href="../articles.php" class="nav">Articles</a> - <a href="../company-profile.php" class="nav">Company profile</a> - <a href="../Newsletters.html" class="nav">Newsletters</a> - <a href="../Tips.html" class="nav">Tips</a> <br /></strong> </td> </tr> <tr> <td width="764" style=""padding-left:10px"" > </td> <td rowspan="3" valign="top" width="181"><img src="../images/leftbanner.jpg" width="181" alt="advance excel courses" border="0" usemap="#Map" /></td> </tr> <tr> <td align="right" ></td> </tr> <tr> <td align="left" valign="top" style="padding:10px; text-align:justify"><p><strong>Tips in Using <a href="../Formulas/Lookup-formulas/Vlookup-formula/Vlookup.php">Vlookup</a> in Excel</strong></p> <p> <a href="../index.php">Microsoft Excel</a> is the most popular productivity tool for spreadsheet manipulations. For those who do not have programming background but need to process records of data for business or personal reasons, Microsoft Excel is the best choice. Simple database manipulation can be easily done with Excel. However, not many users know that they can further maximize their use of the productivity tool by using features that may be considered advanced by some but are actually very simple to implement. <a href="../Formulas/Lookup-formulas/Vlookup-formula/Vlookup.php">Vlookup</a> is a very useful function that allows referencing to a separate table for better organization of spreadsheet. If you have applications where you have specific coding system in your spreadsheet and you want the cells to be automatically filled up, you can use <a href="../Formulas/Lookup-formulas/Vlookup-formula/Vlookup.php">Vlookup</a> instead of manual entries for each row. If you want to explore the use of <a href="../Formulas/Lookup-formulas/Vlookup-formula/Vlookup.php">Vlookup</a> in your spreadsheet, below are some tips to guide you in your use of the function.</p> <p><strong><a href="../excel-courses-sitemap.html">One-day Excel course</a></strong><img src="../images/vlookup4.jpg" alt="excel training" width="259" height="194" hspace="10" vspace="10" align="right" /></p> <p> 1. Use a separate spreadsheet for the look up table. </p> <p> It will be more organized to have a separate matrix that contains the references in your main database. For example, if you have a record of students' grades and you want a defined table, for the equivalent of alphabetic ratings, you can set a table that corresponds to the code. The first column should contain the code and the second one is the complete wording for the alphabetic mark. This can be O in the first column and first row and Outstanding in the second column of the first row. Same can be done for VS, S, NI and F which correspond to Very Satisfactory, Satisfactory, Needs Improvement and Failure, respectively.</p> <p> 2. Instead of using the wizard for writing the <a href="../Formulas/Lookup-formulas/Vlookup-formula/Vlookup.php">Vlookup</a> formula, use Excel's intellisense and fill up the details.</p> <p> It will be best to be familiar with the <a href="../Formulas/Lookup-formulas/Vlookup-formula/Vlookup.php">Vlookup</a> formula. The entries in the parentheses should be easily accomplished if you already know what each entry looks for. Although you can point to the specific locations by just clicking or highlighting the range, it will be faster to specify the range directly. This is also true with the other functions that you will use later on. When you know the syntax of the commands, you will no longer rely on the wizard to assist you in specifying the location of the reference table and the other information. Things become easy and quick.</p> <p> 3. Always remember to use <a href="../Formulas/Lookup-formulas/Vlookup-formula/Vlookup.php">Vlookup</a> for repetitive column entries.</p> <p> If you always keep in mind that <a href="../Formulas/Lookup-formulas/Vlookup-formula/Vlookup.php">Vlookup</a> is available for your reference table, you will be able to save time for manually entering fields for data that can be automatically filled up. It may not look easy during the first use of the function. However, as you get used to it, the process becomes easy and you will later on appreciate the usefulness of the function.<br /> The three tips above will make you easily use <a href="../Formulas/Lookup-formulas/Vlookup-formula/Vlookup.php">Vlookup</a> in your Excel applications. As you practice integrating the function in your Excel spreadsheet, you will see that it is easy to use.</p> <p><a href="http://www.twitter.com/31BestofExcel"><img src="../images/Twitter.jpg" width="144" height="44" border="0" /></a></p> <div class="addthis_toolbox addthis_default_style "> <a class="addthis_button_facebook_like" fb:like:layout="button_count"></a> <a class="addthis_button_tweet"></a> <a class="addthis_counter addthis_pill_style"></a> </div> <script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js#username=xa-4cf49c4f06ec8c9f"></script>  </p> <p><a href="http://www.31bestofexcel.com/articles.php"><< Back to Articles</a></p></td> </tr> <tr> <td colspan="2" align="center" background="../images/background_08.jpg" style="background-repeat:no-repeat"> <a href="../index.php" class="footer">Home</a> | <a href="../testimonials.php" class="footer">Testimonials</a> | <a href="../Terms.php" class="footer">Terms & Conditions</a> | <a href="../contactus.php" class="footer">Contact Us</a> | <a href="../Course-details/Advance-course.php" class="footer">Courses</a> | <a href="../manuals.php" class="footer"><a href="../manuals.php">Excel manuals</a> | <a href="../sitemap.html" class="footer">Sitemap</a> | <a href="../articles.php" class="footer">Articles</a> | </td> </tr> </table> <map name="Map" id="Map"> <area shape="rect" coords="21,63,167,215" href="http://www.31bestofexcel.com/excel-courses-sitemap.php" /> <area shape="rect" coords="2,234,179,315" href="mailto:excelpro@31bestofexcel.com" /> <area shape="rect" coords="5,327,175,412" href="../manuals.php" /> <area shape="rect" coords="3,424,179,505" href="../downloads.php" /> </map> <map name="Map3" id="Map3"> <area shape="rect" coords="21,33,100,103" href="../Course-details/Advance-course.php" /> <area shape="rect" coords="110,33,188,101" href="../index.php" /> <area shape="rect" coords="200,33,273,99" href="../Course-details/Basic-course.php" /> </map> </body> </html>