Help - Need to check a workbook for matching multiple values

Hello - I need assistance as I am having severe brain freeze.

I have a list of Client reference numbers (Sheet 1 - Client log) that are current clients or past clients we have tried to aquire. I now have a seperate list of client references (Sheet 2 - New Leads) that I need to cross reference against the current list of clients (Sheet 1) to find matching client references. Basically it is a list of clients that we want to call to aquire their business, but obviously need to fish out all of them that we have already previously called or have already aquired - which will show on Sheet 1.

Hope that makes sense?

I have attached a workbook containing just the client numbers. I have tried a VLOOKUP but it is clearly not working as it just returns #VALUE - so is no doubt my formula that is wrong.

Assistance would be most appreciated.

Regards

In cell B2 on sheet Client Log, enter the following array formula:

Please Login or Register  to view this content.

Confirm with CTRL+SHIFT+ENTER.

Drag down through row 1117. This will return "Call" next to the number that you should call if it does not show up in your "New Client Leads" sheet.

Originally Posted by TMS

@mcmahobt: Why do you need an Array Formula? COUNTIF does the job.

Regards, TMS

My apologies, not array, but works as well. I hadn't refreshed the page before you had posted, so I was unaware you had responded.