BUSCARV en DOS hojas diferentes EXCEL 2016

In this video, we'll learn how to search in Excel for multiple pieces of data from one sheet to another (cross-reference two Excel sheets). To do this, we'll use the VLOOKUP function in Excel 2016. We'll also work through an example of the VLOOKUP function in Excel. 📗 Working file: https://t.me/Enriquexls 🔴+ VIDEOS + EXCLUSIVE FILES 👇    / @enriquexls   👍 FOLLOW ME ON ALL SOCIAL MEDIA 👍 ✅ Facebook |   / enriqueexls   ✅ Instagram |   / enriquexls   The VLOOKUP function is one of the most used functions in Excel and belongs to the group of lookup and reference functions. This function allows us to search for a value within the first column of a data range. VLOOKUP FUNCTION ARGUMENTS: 1ST: We must specify the value we are searching for. Either by providing the value directly or by placing a cell reference to the value. 2ND: The second argument to the function specifies the entire range containing the data. In this range, it is important to ensure that the column we will need as a result is included. If the table has headers, it is best to exclude them from the range to prevent the function from considering the titles in the search. 3RD: The third argument specifies the column we want to return as a result. 4TH: The last argument to the function is optional, but if we do not provide a value, the VLOOKUP function will perform an approximate search. For the function to perform an exact search, we must enter the value false, and the result will be the value of the column we have specified.