Excel VLOOKUP formula is one of the most widely used excel formulas. As the name suggests, Vlookup or vertical look up helps us to look up the required information using one data set reference in another data set. Combining with other formulas it can be used to analyse complex data sets. Syntax : - VLOOKUP(lookup_value, table_array, col_index_num,[range_lookup]) Below data sets belong to an organization. In Sheet 1 , we have data containing Employee Names and their employee IDs. In Sheet 2 we have the employee IDs and the Bonus detail for the year. Sheet 1 Data Sheet 2 Data Now if we want to get the details of Bonus from the Sheet 2 to Sheet 1, we can use Vlookup formula. Lets see how to po...