Partial Name Search

[mmayna03]

I have two excel spreadsheets in the same workbook. I am using Excel 2007. On the first worksheet I have 6 columns, B2(State), B3(Name[includes First, MI, Last]), B4(Phone 1), B5(Phone 2), B6(Email).

My second worksheet is to seach the the first worksheet. I have vlookups and other search formulas are working fine, except for one.

I want to search based upon the last name in column B3 to return the entire name from B3, I have tried match, index, find and index/match formulas. The returned results are the same #NAME?.

=IF(E10="","",INDEX(SHEET1!B2:G113,MATCH(E10,SHEET1:B2:G113,3)))

E10 is my search criteria.

Any Suggestions?

Thanks,

Michael

 

[MrKowz]

Check out this post for a "Fuzzy Lookup"

http://www.mrexcel.com/forum/showthread.php?p=955137