Combine/merge tables

[tessda]

Hi guys I need some assistance. I have two spreadsheets which I need to combine to provide the data in one table. The two spreadsheets must be combined based on the columns "EMIS NO" which are in both sheets and must contain all the information as provided in the various columns of the sheets. In the attachment it can be seen that the two sheets do not have the same number of rows as some of the information is not available. Can somebody help with a way of doing this? Is there a formula consisting of "IF" , "THEN" statements that can be used. I have tried a number of the functions but could not achieve the desired results.

[arthurbr]

Maye you can start from here using VLOOKUP?