I want to use the lookup function to find the Advisor corresponding to their AdvInits in the Time sheet in the Client List Search workbook while accessing another workbook. I tried the following code but it doesn't find the required value. What do I need to change?

Application.WorksheetFunction.Lookup(AdvInits, Workbooks("Client List Search.xls").Worksheets("Time").Range("S5:S36"), Range("T5:T36"))
Paul