Formula for COUNTIF with more than one VLOOKUP condition / criteria

Hi Everyone,

I'm trying to generate a formula that will count the number of experts with specific expertise in each country and generate the result in Column K (red text).

Table 1 shows experts already available in each country, and their areas of expertise. Table 2 shows expertise that each country is requesting for.

The aim is to assist decision making by reviewing whether the experts requested for (Table 2) for each country already exist in the same country (Table 1), and if yes, how many? If no, also important to know.

I tried but got stuck with combining COUNTIF with two VLOOKUP conditions. My challenge is to have two conditions that must be fulfilled in the formula:
(a) COUNT IF the Country (Column H) in Table 2 is an exact match for the Country (Column A) in Table 1.
AND
(b) COUNT IF the "Expertise" (Column C) is an exact match for "Expertise Requested For" (Column J)


These are two huge tables in actuality, and will refer to the actual table references in the formula e.g. Experts_Table[Expertise] and Requests_Table[Expertise Requested For]

Thank you for the support!

Regards,

Bonyo

Originally Posted by avk

"K3"

Formula:

Please Login or Register  to view this content.

Thank you avk, this is excellent and just what I was looking for - you just saved my life!!