VLOOKUP Examples- fuzzy logic

Please sign up for the course before starting the lesson.

VLOOKUP Ex11

In D4 to D52 we need to pull through the matching email address from column I and J. You can use the surname in column B as the lookup but it will need to be a partial lookup as column I has the persons name and initial.

Because of similar names, in column E check how many times Excel would complete the partial match (hint- you can use the same logic in COUNTIF and COUNTIFS- this is covered later as well)

To see the full course contents click here.

Lesson tags: vlookup
Back to: Advanced Excel Course > Key Lookup Functions