match part of full name

[kasper]

I am looking to get a user's email address.

On Sheet A (Foreseen Absences) I have users enter their own data.
On Sheet B (email addresses) I have users' full names and email addresses.

I have the following formula entered on Sheet A to get the user's email address: =vlookup(C173,'email addresses'!A:C,3,0)

This works fine for staff who enter their full names, but I've got a few who are entering things like: G. Thoms or Marie which results in a #NA error.

Is there an easy way to update this formula to account for these instances?
I can just manually change the few problem names, but would love to learn how to fix update the formula if there is an easy fix.

Thanks!

 

[Joe4]

Is there an easy way to update this formula to account for these instances?

I don't think there is an "easy" answer like you are hoping for. Probably the best bet is to try to incorporate some "fuzzy" matching logic (see: http://www.mrexcel.com/forum/showthread.php?p=955462#post955462).