Sum, count or average with partial matches
As with the VLOOKUP function, the match is assumed to be an exact match i.e. if you are looking for Smith, Excel won’t match it to a cell containing John Smith. But there is a way to make Excel work with this partial match.
Watch the video clip to see how this works.
To see the full course contents click here.