Merge unmerge in excel and vlookup

Question

Accepted Answer

Merging and unmerging cells in Excel and using VLOOKUP function.

To merge cells, select the cells and click on the 'Merge & Center' button in the Home tab.
To unmerge cells, select the merged cell and click on the 'Merge & Center' button again.
VLOOKUP function is used to search for a value in a table and return a corresponding value from another column.
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example: =VLOOKUP(A2, B2:C10, 2, FALSE) will search for the value in cell A2 in the table range B2:C10 and return the value in the second column of the table.