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]
