Matching records

[rireland]

I've lost the Html maker addon & can't download (404 message) it again so will try to explain without it.
I have a list of names, address & member numbers - say 3000.
At year end 2800 of these people pay, using an online payment system. Giving their name, address & member number.
I want to match up the paid people to the member list (using member number as the matching field) . Then I can see what address details need to be updated and who hasn't paid.

1234 John Smith 2 High St... 1234 John Smith 2 High St ( this record is OK)

2341 Jill Jone 3 Low St... 2341 Jill Jone 5 Big St ( by using = on the address field I would find that this needs updating)

3453 Fred Brown 5 Main St ... ( no matching record - so unpaid)

I'm OK on checking if fields are equal, My problem is how to line up the 2800 paid records withe the 3000 member records.

 

[Aladin Akyurek]

Try something like...

=IF(ISNUMBER(MATCH(MemberID,PayerIDs,0)),
    IF(INDEX(PayerAddresses,MATCH(MemberID,PayerIDs,0))=MemberAddress,
      "OK",
      "Update Address"),
    "No Payment")

 

[rireland]

Thanks - I'm not a VBA user but will try it.