Merging two files together...

[AMD3400]

Hey there good people, i have a question, i would like to know if i could merge or should i say group together two column into one, by this i mean, in column A and column D, i want to match those two up, and return one single value, so let say in Col A i have 2230, and in column D i have 2230 also but at a different row number, so i want to match it up into one. can i do that? pls help. Thanks