return the number of times a value appears in another worksheet with VLOOKUP

[rnomis]

I have a spreadsheet that uses a VLOOKUP to return the name of a contact from another sheet:

=IF(ISNA(VLOOKUP(A2,coord!A:B,2,FALSE)),"",VLOOKUP(A2,coord!A:B,2,FALSE)) Column A contains the contact's company reference and B contains the contact's name. This data is exported from the Company database each week and imported into my spread sheet.

This works well. However there are many instances where the company may have more than one contact and I need to identify these to confirm that the contact data I have is up to date.
I want to add another column alongside the column with the formula above that simply returns the number of times the company reference number appears in sheet 'coord' so the data can be checked as sometimes a contact leaves but the record is not updated. I could then be sending emails to someone who is no longer with the client company.

Any help very much apreciated.

[Jonmo1]

Try

=COUNTIF(coord!A:A,A2)

[rnomis]

Great thanks, I had tried various versions of this formula but not in the right order!

[Jonmo1]

Great, glad to help.