PROCV Avançado: Como Buscar Dados em Várias Tabelas ao mesmo tempo no Excel

🟢LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: https://excelentejoao.com.br/sejaexce... 🔵SPREADSHEET: https://excelentejoao.com.br/wp-conte... In this free Excel video lesson, we'll learn how to use VLOOKUP in Excel to search for information in several different tables. The idea is simple, but very powerful: first, we use VLOOKUP to search in one table. If it doesn't find the code, we use IFERROR to do a new search in another table. If it still doesn't find it, we do a third search, and so on. In the example in the lesson, we have a sales table with several types of items mixed together: Products, Services, Plans, or subscriptions. Each item has a code, but these codes are registered in different tables. So, instead of doing everything manually, we created a formula for Excel to automatically search the correct table. You will understand how to create a formula using VLOOKUP with IFERROR to search for data in 2, 3, 4, 5 or even more tables, depending on the needs of your spreadsheet. This type of formula is very useful for those who work with inventory, sales, product registration, service provision, financial control, sales reports and databases in Excel. How to use VLOOKUP in Excel, How to use IFERROR with VLOOKUP, How to search for data in several different tables, How to make VLOOKUP search in another table when it doesn't find the value, How to organize a sales table with products, services and plans, How to automate searches in databases in Excel, How to create a smarter formula for queries in Excel. #ExcellentJoão #Excel #Dashboard