In this Excel video tutorial, we will learn how to use the Lookup function in the Excel spreadsheet, Lookup formula in Excel. When VLookup does not work and when HLookup does not work, you can use Lookup formula. You can use this search function in Excel instead of Xlookup and index match as well.

These functions are search function in Excel, search functions. They serve to automate repetitive processes and tasks.

Just imagine that you have a sales list where you need to fill in the costs of the products, however, instead of checking product by product in another spreadsheet where you have the cost table, it is much easier to use a search function.

This way, you don't need to search, Excel will do the work for you. This is a great way to save time in your daily life and in the job market with Excel, by automating repetitive tasks and processes.

The VLOOKUP function can be used when you need to find items in a table or a range by row.

Example, you need to look up the price of an auto part by the part number or find an employee's name based on the employee ID.

However, VLookup has an error in Excel. It only returns values that are to the right of the reference column, so if you need to return a value that is to the left of the reference column, Vlookup will not work. We can then use the XLookup function or even index with match.

The LOOKUP function can be used when you need to find things in rows of a table or range.

Example, when searching for the price of an auto part by the part number, or find an employee name based on the employee ID.

With LOOKUP, you can search in one column for a search term and return a result from the same row in another column, regardless of whether the return column is on the right or left side of the reference column.

The INDEX function returns a value or reference to a value from within a table or range, that is, it returns the value of an element in a table or matrix, selected by the row and column number indexes.

The MATCH function searches for a specified item in a range of cells and returns the relative position of that item in the range.

As an example, if the range A1:A3 contains the values 10, 20, and 30, the formula =MATCH(20,A1:A3,0) returns the number 2, because the number 20 is the second item in the selected range.

Now that we know how to use the functions above, we can combine functions in Excel, that is, join two functions within the same cell in Excel.

But we can also use the Lookup function in the Excle spreadsheet for the same purpose as the corresponding index function.

And in this free Excel tutorial, we will use the Lookup Function to replace Xlookup and Vlookup.

#JopaExcel #Dashboard #Excel