Excel: Compare Data and Show Differences

Hello, I have four columns of data - column "a" has a name column "b" has a dollar amount column "c" has a name and column "d" has a dollar amount. I want to compare the names in column "a" to the names in column "c" and if they match subtract column "b" from column "d" to show the difference. I've tried everything I can think of, but can't get it to work. Any assistance would be appreciated. Thank you

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of September 03, 2014.

For more resources for Microsoft Excel