I have a worksheet where last name and first name is in separate columns and then i have a worksheet with first, middle and last names in one column. Is it possible to find out whether the names in the second worksheet (all together) are located in the first worksheet where everything is separate. so i want to do an approximate match just in case the middle initial is throwing things off. any help would be greatly appreciated.