Comparing the two excel sheet, what formula is required

VJKJVK Posts 1 Registration date Monday July 15, 2013 Status Member Last seen July 15, 2013 - Jul 15, 2013 at 04:09 AM
I have two excel sheets one column haveing the same numbers both the sheets,

Now in same number I have alloted different compaines, now I need to allocated the amount for perticular company for perticular number.

Kindly help me what formula i need to write.