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...