How to Merge Two tables in excel

I have two tables(Tabl_A and Table_B) in Excel as shown in the following figure. I want to merge them so that output is like the third table (Tabl_C).

stack overflow.PNG


Cross-posted here :
http://www.msofficeforums.com/excel/...les-excel.html
https://www.excelguru.ca/forums/show...ables-in-excel
https://www.mrexcel.com/forum/excel-...les-excel.html

Mod note : Links corrected : should now work

And yet another one : https://stackoverflow.com/questions/...ables-in-excel

Links to cross-posted threads do not work (all 3)!

make first cell in Table_C ControlSet column active, and start writing a formula
=VLOOKUP(
now select cell with 1 in column Sections (one left from the cell you are writing formula in),
write comma (,) in a formula,
select whole TAble_A,
write comma (,) in a formula,
write 2 (as column with ControlSet is 2nd one)
write comma (,) in a formula,
write FALSE and press Enter (closing bracket should be added automatically).
As it is in the table, the formula shall be copiued automatically down.

repeat all steps for next column