{"id":433972,"date":"2022-04-19T14:00:13","date_gmt":"2022-04-19T11:00:13","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/13-essential-excel-functions-for-data-entry\/"},"modified":"2022-04-19T14:00:13","modified_gmt":"2022-04-19T11:00:13","slug":"13-essential-excel-functions-for-data-entry","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/13-essential-excel-functions-for-data-entry\/","title":{"rendered":"#13 Essential Excel Functions for Data Entry"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6ade9676783d4\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6ade9676783d4\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/13-essential-excel-functions-for-data-entry\/#%E2%80%9C13_Essential_Excel_Functions_for_Data_Entry%E2%80%9D\" >&#8220;13 Essential Excel Functions for Data Entry&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/13-essential-excel-functions-for-data-entry\/#Enter_the_Current_Date_and_Time_TODAY_and_NOW\" >Enter the Current Date and Time: TODAY and NOW<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/13-essential-excel-functions-for-data-entry\/#Obtain_Parts_of_a_Text_String_LEFT_RIGHT_and_MID\" >Obtain Parts of a Text String: LEFT, RIGHT, and MID<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/13-essential-excel-functions-for-data-entry\/#Change_the_Letter_Case_UPPER_LOWER_and_PROPER\" >Change the Letter Case: UPPER, LOWER, and PROPER<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/13-essential-excel-functions-for-data-entry\/#Round_Your_Numbers_ROUNDUP_and_ROUNDDOWN\" >Round Your Numbers: ROUNDUP and ROUNDDOWN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/buradabiliyorum.com\/en\/13-essential-excel-functions-for-data-entry\/#Remove_Unnecessary_Spaces_TRIM\" >Remove Unnecessary Spaces: TRIM<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/buradabiliyorum.com\/en\/13-essential-excel-functions-for-data-entry\/#Compare_a_Value_and_Return_a_Result_IF\" >Compare a Value and Return a Result: IF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/buradabiliyorum.com\/en\/13-essential-excel-functions-for-data-entry\/#Look_Up_Values_XLOOKUP\" >Look Up Values: XLOOKUP<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9C13_Essential_Excel_Functions_for_Data_Entry%E2%80%9D\"><\/span>&#8220;13 Essential Excel Functions for Data Entry&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Entering data in your spreadsheet is the basic principle behind using Excel.\u00a0From adding the current date and time to looking up values to changing the letter case of your text, some\u00a0functions can help you\u00a0tremendously with data entry.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Enter_the_Current_Date_and_Time_TODAY_and_NOW\"><\/span>Enter the Current Date and Time: TODAY and NOW<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You may want to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/767135\/how-to-insert-todays-date-in-microsoft-excel\/\">see the current date with or without the time with each opening of your sheet. The TODAY function provides the current date, and the NOW function provides the date and time.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Insert Today&#8217;s Date in Microsoft Excel<\/em><\/strong><\/p>\n<p>The syntax for each function is simple enough. Use <code>TODAY()<\/code> and <code>NOW()<\/code> with no arguments or characters in the parentheses.<\/p>\n<p>Just enter the following formula for the function you want, press Enter or Return, and each time you open your sheet, you\u2019ll be current.<\/p>\n<pre>=TODAY()<\/pre>\n<pre>=NOW()<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-791847\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/TodayNow-ExcelDataEntryFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"TODAY and NOW functions in Excel\" width=\"320\" height=\"120\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Obtain_Parts_of_a_Text_String_LEFT_RIGHT_and_MID\"><\/span>Obtain Parts of a Text String: LEFT, RIGHT, and MID<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you\u2019re working with strings of text where you need to obtain part of that string for your entry, you can do so with the LEFT, RIGHT, and MID functions.<\/p>\n<p>The syntax for each function is as follows:<\/p>\n<ul>\n<li><code>LEFT(text, number_characters)<\/code>, first argument required<\/li>\n<li><code>RIGHT(text, number_characters)<\/code>, first argument required<\/li>\n<li><code>MID(text, start_number, number_characters)<\/code>, all arguments required<\/li>\n<\/ul>\n<p>With this formula, you can obtain the first five characters in the text string in cell A1:<\/p>\n<pre>=LEFT(A1,5)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-791849\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/Left-ExcelDataEntryFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"LEFT function in Excel\" width=\"430\" height=\"125\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>With the next formula, you can obtain the last five characters in the text string in cell A1:<\/p>\n<pre>=RIGHT(A1,5)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-791850\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/Right-ExcelDataEntryFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"RIGHT function in Excel\" width=\"430\" height=\"125\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And with this formula, you can obtain the five characters starting with the seventh character in cell A1:<\/p>\n<pre>=MID(A1,7,5)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-791851\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/Mid-ExcelDataEntryFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"MID function in Excel\" width=\"430\" height=\"125\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Change_the_Letter_Case_UPPER_LOWER_and_PROPER\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">Change the Letter Case: UPPER, LOWER, and PROPER<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Maybe you have some inconsistencies in the way the text in your sheet was entered. You can <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/164598\/how-to-quickly-and-easily-change-case-in-excel-2013-using-a-function\/\">convert letters to all uppercase or lowercase, or capitalize the first letter of each word with UPPER, LOWER, and PROPER.<\/p>\n<p>The syntax for each is the same with the argument required:<\/p>\n<ul>\n<li><code>UPPER(cell_reference)<\/code><\/li>\n<li><code>LOWER(cell_reference)<\/code><\/li>\n<li><code>PROPER(cell_reference)<\/code><\/li>\n<\/ul>\n<p>To change the text in cell A1 to all uppercase letters, use the following formula:<\/p>\n<pre>=UPPER(A1)<\/pre>\n<p>To change the text in that same cell to all lowercase letters, use this formula instead:<\/p>\n<pre>=LOWER(A1)<\/pre>\n<p>To change the text in that cell to capitalize the first letter of each word, use this formula:<\/p>\n<pre>=PROPER(A1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-791846\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/Proper-ExcelDataEntryFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"PROPER function in Excel\" width=\"430\" height=\"170\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Round_Your_Numbers_ROUNDUP_and_ROUNDDOWN\"><\/span>Round Your Numbers: ROUNDUP and ROUNDDOWN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You might have a spreadsheet containing decimal numbers that you prefer to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/356645\/how-to-round-off-decimal-values-in-excel\/\">round up or down, rather than display the entire string. The ROUNDUP and ROUNDDOWN functions in Excel let you round numbers easily.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Round Off Decimal Values in Excel<\/em><\/strong><\/p>\n<p>The syntaxes are <code>ROUNDUP(number, number_digits)<\/code> and <code>ROUNDDOWN(number, number_digits)<\/code> where both arguments are required for each.<\/p>\n<p>To round the number in cell A1 up two digits, use this formula:<\/p>\n<pre>=ROUNDUP(A1,2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-791853\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/RoundUp-ExcelDataEntryFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"ROUNDUP function in Excel\" width=\"475\" height=\"125\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To round that same number down two digits, you\u2019d use this formula:<\/p>\n<pre>=ROUNDDOWN(A1,2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-791854\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/RoundDown-ExcelDataEntryFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"ROUNDDOWN function in Excel\" width=\"500\" height=\"125\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Use a positive number for the <code>number_digits<\/code> argument to round decimal places to the right and a negative number to round decimal places to the left.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Remove_Unnecessary_Spaces_TRIM\"><\/span>Remove Unnecessary Spaces: TRIM<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Maybe you have extra spaces in your cells that you want to remove. The <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/710718\/how-to-use-the-trim-function-in-microsoft-excel\/\">TRIM function eliminates spaces.<\/p>\n<p>The syntax for the function is <code>TRIM(text)<\/code> where you can use a cell reference or enter the text in quotes.<\/p>\n<p>To remove the extra spaces in the text in cell A1, use the cell reference as in this formula:<\/p>\n<pre>=TRIM(A1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-791857\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/Trim-ExcelDataEntryFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"TRIM function in Excel\" width=\"420\" height=\"125\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To remove the additional spaces in the phrase <code>\"\u00a0\u00a0 Extra\u00a0\u00a0 Spaces\u00a0\u00a0 \"<\/code> you would use the following formula:<\/p>\n<pre>=TRIM(\"\u00a0\u00a0 Extra\u00a0\u00a0 Spaces\u00a0\u00a0 \")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-791856\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/TrimText-ExcelDataEntryFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"TRIM text in Excel\" width=\"530\" height=\"125\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Compare_a_Value_and_Return_a_Result_IF\"><\/span>Compare a Value and Return a Result: IF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/401998\/how-to-use-logical-functions-in-excel-if-and-or-xor-not\/\">IF function is a popular tool for comparing values and returning numerical or textual results. You can then analyze those results or use them elsewhere like in another formula.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Use Logical Functions in Excel: IF, AND, OR, XOR, NOT<\/em><\/strong><\/p>\n<p>The syntax is <code>IF(test, output_if_true, output_if_false)<\/code> where the first two arguments are required.<\/p>\n<p>To test the value in cell A1, which is a Yes or No option, and return a 1 for Yes and 2 for No, you would use this formula:<\/p>\n<pre>=IF(A1=\"Yes\",1,2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-791862\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/IfYes-ExcelDataEntryFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IF a value equals function\" width=\"465\" height=\"140\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For a text example, you can see if a value (A1) is greater than another value (B1) and then return \u201cOver\u201d if it is and \u201cUnder\u201d if it isn\u2019t.<\/p>\n<pre>=IF(A1&gt;B1,\"Over\",\"Under\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-791861\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/IfOver-ExcelDataEntryFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IF a value is greater than function\" width=\"540\" height=\"140\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Look_Up_Values_XLOOKUP\"><\/span>Look Up Values: XLOOKUP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you need to look up a value or text from another location and enter it in your sheet, the XLOOKUP function is ideal.<\/p>\n<p>The syntax is <code>XLOOKUP(value, lookup, return, not_found, match_code, search_code)<\/code> where the first three arguments are required and the last three are optional.<\/p>\n<p>Because we have a full <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/439286\/how-to-use-the-xlookup-function-in-microsoft-excel\/\">tutorial on the XLOOKUP function in Excel that goes into further detail, we\u2019ll use basic examples here.<\/p>\n<p>To find the phone number for a customer, you can use this formula:<\/p>\n<pre>=XLOOKUP(H2,A2:A10,C2:C10)<\/pre>\n<p>To break down the formula, H2 is the value to find, A2:A10 is where to look up the value, and C2:C10 is where to find the value to return.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-791859\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/XLookupPhone-ExcelDataEntryFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"XLOOKUP for one field\" width=\"650\" height=\"263\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>As another example, you can use this formula to find both the phone number and the email address for that customer:<\/p>\n<pre>=XLOOKUP(H2,A2:A10,B2:C10)<\/pre>\n<p>Here, we simply expanded the <code>return<\/code> argument to cover each column that includes the phone number and email address (B2:C10). So, the formula provided both results.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-791860\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/XLookupEmailPhone-ExcelDataEntryFunctions.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"XLOOKUP for two fields\" width=\"650\" height=\"215\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Data entry is enough of a task on its own. Hopefully you can make it easier using these Excel data entry functions. Do you have different functions that help you enter data in Excel? Let us know!<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Create a Data Entry Form in Microsoft Excel<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/791838\/excel-functions-data-entry\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;13 Essential Excel Functions for Data Entry&#8221; Entering data in your spreadsheet is the basic principle behind using Excel.\u00a0From adding the current date and time to looking up values to changing the letter case of your text, some\u00a0functions can help you\u00a0tremendously with data entry. Enter the Current Date and Time: TODAY and NOW You may&#8230;<\/p>\n","protected":false},"author":1,"featured_media":433973,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-433972","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/433972","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=433972"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/433972\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/433973"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=433972"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=433972"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=433972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}