If the quantity is not equal to zero, it will return “ Yes” that is, the stock is in hand.Puneet? Because vlookup with approximate match retrieves the closest value that is less than the lookup value.And using “IF”, this Vlookup result will be compared with “0”. Manish Patil, that age is 48, but 43 is much closer to 44 than 48. Puneet Sharma, whose age is 43, while we also have Mr. Then we can get the approximate matching value.Īs you see, the formula returns Mr. Now I want to put the age value in k2 then we get the employee name which is approximate age as given in k2 age value as showing below mention pictures. You can take this as an array or master table. We can see that in a table, all values are matching the exact value.Īs above showing in the picture in the H column, there is employee age mention and column I employee name. So then we need to put the 0 for exact matching or 1 for false matching. Master data table b, as above showing, is a table array, and in master data, you can see that mobile no column is on the 5 number column index. So as the employee name is a unique column, then the employee names a lookup value in a table where you want to get a result. And you have another table where required only contact no of the employee. So you can suppose as array table or master table data. To search for an exact match, you put false in the last argument.Īs mentioned in table b, there is all employee information like department, employee id, address, mobile no, etc.
#How to use vlookup in excel 2016 youtube download#
You can download this VLOOKUP Function Template here – VLOOKUP Function Template Example #1 – Exact Match Below mention are the details using the formulas. Let us understand the working of vlookup.
Vlookup function is very simple and easy to use. We can also use one sheet to another sheet and one workbook to another workbook also. This function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index number position. When the user uses the vlookup function for finding specific information in an MS Excel spreadsheet, each matching information is displayed in the same row but in the next column. This function helps you to locate specific information in your spreadsheet. = vlookup (lookup value, table range, column index) > enter
False – exact match if an exact match is not found, then it will return an error.True – approximate match if an exact match is not found, use the closest match below the lookup value.The argument can be set to true or false, which means: Range lookup (optional argument) defines what this function should return if it does not find an exact match to the lookup value.If you are only using it for data matching, you can put 1, but if you want to get a value from another column to match the lookup value, you need to put column no from matching column no. Column index number (required argument) – an integer specifying the column number of the supplied table array that you want to return a value from.We can say that this is a matching table. The vlookup function searches in the left-most column of this array. Table array (required argument) – it is the data array that is to be searched.Where you want or get the value from another table. Lookup value (required argument) is the value that we want to look up in a table column.There are four arguments in the vlookup function, which is below mention: The vlookup function uses of the arguments:. Excel functions, formula, charts, formatting creating excel dashboard & others
0 kommentar(er)
