CLICK HERE TO LEARN MORE ABOUT THE AWESOME COMPLETE EXCEL COURSE: https://lp.hashtagtreinamentos.com/es... -------------------------------------------------------------------- DOWNLOAD THE MINI COURSE ON FORMS IN EXCEL: http://bit.ly/2F3drL5 ----------------------------------------------------------------------- ► Spreadsheet used in the video: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/i... ----------------------------------------------------------------------- Hashtag Treinamentos ► Subscribe to our channel: https://bit.ly/2O6A4RP ► Turn on notifications (click on the bell)! ► Like our video! ----------------------------------------------------------------------- Social Networks ► YouTube: https://bit.ly/2O6A4RP ► Instagram: https://bit.ly/2F7B6t4 ► Facebook: https://bit.ly/2UA4SwY ----------------------------------------------------------------------- TOP Videos: ► 5 Steps to Learn How to Make a Pivot Table in Excel • 5 Steps to Learn How to Make a Pivot Table... ► VLOOKUP - Complete Step by Step (without complications) • VLOOKUP - Complete Step by Step (without c... ► IF Function - I'll explain to you on the beach how to do the IF formula! • IF Function - I'll explain to you on the beach how to ... ► How to make your Excel spreadsheet more beautiful and impress your boss • How to make your Excel spreadsheet more beauti... ► How to recover an unsaved Excel spreadsheet • How to recover an unsaved Excel spreadsheet ----------------------------------------------------------------------- In today's video we're going to show you how to do VLOOKUP in reverse! That's right, with the INDEX formulas and MATCH we will be able to do what the VLOOKUP function cannot! First, let's see how to build and use the INDEX formula. This formula is used to return the value that is in position x from a list. In the example, we have a list with several codes. When using the INDEX formula with this list (B3:B7) and entering a position number (3), the formula returns the code that is in the entered position of this list (AB0003). The INDEX function is often used to work with Excel buttons, and it is also very useful when combined with the MATCH function. With this formula, we can find an employee's code just by entering the list where he is and his position in the list. Now we need to learn the MATCH formula. The function of this formula is to find the position of a value in a list. In other words, I need to pass it a value that I want to search for, a column (or row) where this value is and also whether I want to search for exactly this value or approximations of it. In practice, the formula searches for a certain value in a list and returns the position in that list where the value is. For example, I can search for an employee (Renato) in the list of names (C3:C7) and tell the formula that I want to search for Renato (0). The formula will return Renato's position in the list of names (3). Now that I have used the INDEX MATCH formulas separately, I can combine the two to first find the person's position in the list (Renato's position in the list is 3rd). Then, I can inform this position (3rd) and the list (B3:B7) to the INDEX formula and it will return the value that is in that position (3rd) in that list (B3:B7), in this case it is the code AB0003. The great advantage of using the INDEX + MATCH combination instead of the VLOOKUP formula is being able to search for a value (or text) in a column (or row) and return information that is to the left of that value. ----------------------------------------------------------------------- #excel #vba #hashtagtreinamentos