Help subtracting B from F if values in Column A and E match

[carlinhosg]

I need help creating a formula that will subtract values on Columns B from F if the values on Columns A and E match. I'd like the results to be displayed on columns C. So cell C3 would be 400, C4 would be 100... C8 would be -600

Can Someone help? Thanks in advance.

Book2
	A	B	C	D	E	F
2
3	Carlos	500			Adriana	600
4	Jorge	400			Jorge	300
5	Samara	300			Samara	200
6	Mike	200			Carlos	100
7	Nygel	100			Mike	50
8	Adriana				Nygel
9	Gene				Gene
10					Diane
11					Jeff
Sheet1

 

[BJungheim]

Try:

=IF(ISNA(MATCH(A3,$E$3:$E$11,0)),"",B3-INDEX($F$3:$F$11,MATCH(A3,$E$3:$E$11,0)))

Which will display a blank cell if there is no match.

Or:

=IF(ISNA(MATCH(A3,$E$3:$E$11,0)),B3,B3-INDEX($F$3:$F$11,MATCH(A3,$E$3:$E$11,0)))

Which will display the value in column B if there is no match.

 

[carlinhosg]

That worked beautifully. Thanks for the quick reply!