Queries of countifs or other excel functions that may help my work

[bestrong_ting]

Hello Everyone.
I have some questions to ask.
I have two lists to compare, which is the report list and payment list.
I have to find which amount is omitted in the report list from the payment list.
In my example, payment of member 0009 and 0020 of $30 and $70 respectively are omitted.
I used to use the =countif()>0 function but then I found that $30 and $70 are not unique values for counting and lookup.
I know the countifs function may help but I do not know how to set up.
May somebody help me to set up functions to lookip thousands of records omitted in the report list?

[TABLE="class: grid, width: 606, align: center"]
<tbody>[TR]
[TD]A1
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Report List
[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Payment List
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Membership No.
[/TD]
[TD]Amount
[/TD]
[TD][/TD]
[TD]Membership No.
[/TD]
[TD]Amount
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]0003
[/TD]
[TD]20
[/TD]
[TD][/TD]
[TD]0003
[/TD]
[TD]20
[/TD]
[TD][/TD]
[TD]=COUNTIF($C$4:$C$9,F4)>0
[/TD]
[TD]TRUE
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]0002
[/TD]
[TD]30
[/TD]
[TD][/TD]
[TD]0002
[/TD]
[TD]30
[/TD]
[TD][/TD]
[TD]=COUNTIF($C$4:$C$9,F5)>0
[/TD]
[TD]TRUE
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]0003
[/TD]
[TD]70
[/TD]
[TD][/TD]
[TD]0003
[/TD]
[TD]70
[/TD]
[TD][/TD]
[TD]=COUNTIF($C$4:$C$9,F6)>0
[/TD]
[TD]TRUE
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]0004
[/TD]
[TD]90
[/TD]
[TD][/TD]
[TD]0004
[/TD]
[TD]90
[/TD]
[TD][/TD]
[TD]=COUNTIF($C$4:$C$9,F7)>0
[/TD]
[TD]TRUE
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]0015
[/TD]
[TD]200
[/TD]
[TD][/TD]
[TD]0009
[/TD]
[TD]30
[/TD]
[TD][/TD]
[TD]=COUNTIF($C$4:$C$9,F8)>0
[/TD]
[TD]TRUE
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]0034
[/TD]
[TD]700
[/TD]
[TD][/TD]
[TD]0015
[/TD]
[TD]200
[/TD]
[TD][/TD]
[TD]=COUNTIF($C$4:$C$9,F9)>0
[/TD]
[TD]TRUE
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0020
[/TD]
[TD]70
[/TD]
[TD][/TD]
[TD]=COUNTIF($C$4:$C$9,F10)>0
[/TD]
[TD]TRUE
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0034
[/TD]
[TD]700
[/TD]
[TD][/TD]
[TD]=COUNTIF($C$4:$C$9,F11)>0
[/TD]
[TD]TRUE
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Tetra201]

Put the following formula in cell H4 and copy down:

=IF(COUNTIFS(B:B,E4,C:C,F4)=0,"Omitted","")