Rearrange data using VLOOKUP excel

VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. This function is lookup a value in a table by matching on the first column. The syntax of the function as follows: =VLOOKUP (value, table, col_index, [range_lookup]) where:value – The value to look for in the first column of … Read more