ProcV com mais de Um resultado | Procv com dados repeditos

In this Excel video tutorial, I'll show you how to perform a VLOOKUP with repeated values, and how to perform a VLOOKUP in Excel with more than one result. Well, before I explain how to do this, it's important to understand what the Excel VLOOKUP function is. The VLOOKUP function is a vertical search function; that is, you enter a value into the formula, and it searches for the desired reference. For example, in a list, you have the name of a material and its price. Instead of having to search for, say, how much an orange cost, you can tell VLOOKUP to find the price of an orange. Then, you type what you're looking for, and the function returns the desired result—in this example, the price. 🔥 FREE LIVE EVENT REGISTER ⬇⬇⬇ http://excelentejoao.com.br/evento-ao... #ExcelenteJoão #Excel #Dashboard Now, to perform this function in Excel with more than one result, you'll need to create some auxiliary columns to help the function search for exactly what you need. You can use this same step-by-step guide, this same practical example, and use it with other important Excel functions. For example, LookupX, LookupH, Index, and Match.