I have in Worksheets("TSA Request").Range("F4") the name of an agent lets say its "Joe Smith" and on Worksheets("CS Data") in column F is their 1st name and column E is their last name - I want for it to search for the agents name and return the value in cell Worksheets("TSA Request").Range("F3"). Any help would be greatly appreciated!