#HOW TO USE VLOOKUP IN EXCEL 2013 HOW TO#

You can’t select the range to look up from another spreadsheet. Unfortunately, the flow described above for VLOOKUP does not work with Excel Online workbooks.

#HOW TO USE VLOOKUP IN EXCEL 2013 HOW TO#

Step 1: Open the spreadsheet containing the #N/A value that you want to replace. How to vlookup another Excel Online file. By following the steps below, that will be replaced with a “0”. The formula will display #NA when it does not find the information that it is looking for. The steps below will assume that you already have an existing VLOOKUP formula in place in your spreadsheet, but that you would like it to display a “0” instead of #N/A. How to Modify the VLOOKUP Formula in Excel 2013 to Display a Zero Instead of #N/A Fortunately you can make a minor alteration to your VLOOKUP formula to display a “)” instead of the #N/A error message. We’ll look at each component individually. In the latest version of Excel (2010 at the time of this writing), the syntax for a VLOOKUP automatically appears once you type in the formula and an open parenthesis. This can be problematic, especially if the appearance of your data is important. The syntax for VLOOKUP has changed over time to make it simpler and easier to use. It can save an incredible amount of time when compared to manually searching for cell data, and has the added benefit of being repeatable and accurate.īut if the VLOOKUP formula can’t find the information that it is looking for, it will display an error in the form of #N/A. Along with the concatenate formula, I have found it to be one of the more useful tools in Excel. While the above example is a very simple one, you can trust the VLOOKUP function to work flawlessly, when you are dealing with large amounts of data.The VLOOKUP formula in Microsoft Excel is one of the most efficient ways to find data in spreadsheets. Learn the best way to use the Microsoft Excel 2013 Formula, taught by Zack Barresse, a Microsoft Excel MVP, at Excel and Access, LLC Website: Linkedin: https://www. Once you hit the Enter Key, VLOOKUP function will lookup (Chromebook) in Column A and bring up the price of Chromebook from Column E. Close the bracket and hit the Enter Key on the keyboard of your computer. The last part is : As explained above, simply pick False to indicate that you want to find the exact match for the price of Chromebook.ħ. The next part is Column_Index_Num – Type 5 to indicate that the price of item (Chromebook) that you want to lookup is located in the 5th column from left.Ħ. Next, select Cells A1:F10 as the Table_array – This is where the data that you want to scan is located.ĥ.

Going by the Syntax, select Cell E3 as the Lookup_value – This is where you typed the Name of item that you want to Lookup (Chromebook).Ĥ. Next, start typing =VLOOKUP in Cell B13 and Excel will automatically provide you with the Syntax to follow.ģ. Start by typing the Name of item that you want to lookup in Cell A13 – In our case, the item that we want to lookup is Chromebook.Ģ. The task in this example is to use the VLOOKUP Function to lookup (Chromebook) and bring up the price of Chromebook in Cell B13.ġ. The Sales Data as provided below has item Names in Column A and corresponding Prices of these items in Column E. This post will guide you how to use VLOOKUP function to look up values based on an exact or approximate match in Excel 2013/2016 or the higher versions. If the specified parameter is False, VLOOKUP searches for the exact match. If the specified parameter is True, VLOOKUP searches for the approximate or nearest match. Table_Array: This is where the data to lookup is located.Ĭol_Index_Num: Column Number from which the lookup value should be returned. Lookup_Value: This is the item that you want to lookup. =VLOOKUP (Lookup_value, Table_array, Col_index_num, ) You can use VLOOKUP to match two values and return a value of data in a different column but the same row.

The VLOOKUP function has the following Syntax: The VLOOKUP, the V stands for vertical, is one of the simplest formulas in Excel but can cut down your time dramatically when comparing large chunks of data. However, you do need to understand the Syntax, in order to clearly understand this function. Hence, there is really no need to remember the Syntax of VLOOKUP Function. Microsoft Excel automatically provides you with the syntax for VLOOKUP Function as soon as you start entering =VLOOKUP in any cell of an Excel Spreadsheet. To understand this better, let us go ahead and take a look at the Syntax and the steps to use VLOOKUP Function in Excel. In this case, the VLOOKUP Function can be used to list the Price of Items by looking up Item Names in the ‘Names’ Column and their corresponding Prices located in another column.

How to use vlookup in excel 2013