![how to use vlookup in excel to link two datas how to use vlookup in excel to link two datas](https://contexturesblog.com/wp-content/uploads/2010/08/vlookupotherfile01c.png)
Note: Both the text & numeric data in the array must be sorted in ascending order. Mostly it will have a two-dimensional array (table) of data, values in the column or row of the array,
![how to use vlookup in excel to link two datas how to use vlookup in excel to link two datas](https://i.ytimg.com/vi/pABOq2bky-A/hqdefault.jpg)
Note: Prior to performing a lookup function, it must be sorted in ascending order. It’s a single column or single row of data that is sorted in ascending order, where the LOOKUP function searches for a value in this range or when you want to specify the range or table array that contains the values that you want to match. Lookup_vector: vector refers to a one-column or one-row range.Lookup_value: A value that LOOKUP searches for in an array, “Array” is a collection of values in rows and columns it can be a text, number or a reference to a cell containing the lookup value.LOOKUP Formula has the following arguments: There are 2 types of formulas for the LOOKUP function.
![how to use vlookup in excel to link two datas how to use vlookup in excel to link two datas](https://www.mrexcel.com/img/content/2018/03/replacing-vlookup-using-the-data-model-and-relationships-01.jpg)
When you need to search for specific data in one row or one column, it will use the lookup function its main purpose is to Lookup a value in a one-column or row range or an array (two-dimensional array (table) of data. Excel functions, formula, charts, formatting creating excel dashboard & others