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

carlinhosg

Board Regular
Joined
Mar 22, 2005
Messages
64
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
ABCDEF
2
3Carlos500Adriana600
4Jorge400Jorge300
5Samara300Samara200
6Mike200Carlos100
7Nygel100Mike50
8AdrianaNygel
9GeneGene
10Diane
11Jeff
Sheet1
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

BJungheim

Well-known Member
Joined
Jul 24, 2004
Messages
914
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,822
Messages
5,574,520
Members
412,600
Latest member
Andyb2
Top