LOOKUP Function is better than VLOOKUP Practical Step by Step Example Excel Search Formula
27,362 views
About :
🟢 LEARN EXCEL WITH ME AND BECOME A REFERENCE IN THE JOB MARKET: http://excelentejoao.com.br/sejaexcel... #Excelentejoao #Excel #Dashboard In this Excel video lesson, we will learn how to use the Lookup function in the Excel spreadsheet, the Lookup formula in Excel. When Lookup V doesn't work and when Lookup H doesn't work, you can use the LOOKUP function. You can use this search function in Excel instead of lookup x and index match too. These functions are search functions in Excel, search functions. They are used to automate repetitive processes and tasks. Just imagine that you have a sales list where you need to fill in the product costs, 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 have to search, Excel will do the work for you. This is a great way to save time in your day-to-day work and in the 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. For example, you need to look up the price of an auto part by part number or find an employee's name based on the employee's ID. However, VLOOKUP has a bug 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 does not work. We can then use the XLOOKUP function or even index with match. The XLOOKUP function can be used when you need to find things in rows of a table or a range. For example, when looking up the price of an auto part by part number or finding an employee's name based on the employee's ID. With XLOOKUP, 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 to the right or left of the reference column. The INDEX function returns a value or a reference to a value from a table or range, that is, it returns the value of an element in a table or array, selected by 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. For example, if the range A1:A3 contains the values 10, 20, and 30, the formula =MATCH(20,A1:A3,0) will return the number 2, because the number 20 is the second item in the selected range. Now that we know how to use the above functions, 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 Excel spreadsheet for the same purpose as the index match function. And in this free Excel tutorial, we will use the LOOKUP function to replace XLookup and VLookup.
559,134 views 1 day ago
523,888 views 3 days ago
561,570 views 4 days ago
6,154,214 views 13 days ago
1,205,629 views 3 days ago
375,625 views 18 hours ago
1,291,205 views 2 days ago
908,418 views 1 day ago
109,772 views 16 hours ago
5,592,513 views 2 weeks ago
Google AdSense
336 x 280
336 x 280
Up Next
Abner Pires
3,333 views
1 year ago
1 year ago
Janusz Fachowiec
17,024 views
2 years ago
2 years ago
Edu car Faróis
8,717 views
1 year ago
1 year ago
E36 Garage
4,322 views
7 months ago
7 months ago
Abner Pires
12,304 views
1 year ago
1 year ago
Mecânicos de garagem
44,774 views
4 years ago
4 years ago
147 Garage
2,224 views
2 months ago
2 months ago
147 Garage
11,508 views
1 year ago
1 year ago
Racetech drag race team
10,627 views
9 months ago
9 months ago
DigoMK4
41,090 views
4 years ago
4 years ago
Nascar Auto Sport
26,441 views
3 years ago
3 years ago
Morcego Digital
11,340 views
9 months ago
9 months ago
Me Ensina
74,200 views
4 years ago
4 years ago
Gabriela Charbe
207,497 views
4 years ago
4 years ago
Especialista em TI
61,350 views
3 years ago
3 years ago
Curso Rápido
50,225 views
4 years ago
4 years ago
Makina de Ideias
24,349 views
Streamed 3 years ago
Streamed 3 years ago
Conecta Nuvem - Workspace - Google Cloud Partner
28,131 views
2 years ago
2 years ago
Bruno Siqueira - Simplificando Celular
556,716 views
3 years ago
3 years ago
Profa. Miriam Navarro
31,686 views
1 year ago
1 year ago
Flavio de Lima
25,170 views
5 years ago
5 years ago
Google AdSense
336 x 280
336 x 280