problem accessing lookup list from sheet in another workbook

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?

Please Login or Register  to view this content.

Paul

Roy

I want to use this lookup in the middle of a macro. The complete code for that line is:

Please Login or Register  to view this content.

Paul

Thanks Roy, but I would still like to use lookup or vlookup but I don't know how to write correct this code within the lookup function. Can anyone help with this?

Please Login or Register  to view this content.

Paul

Roy,

I'm really sorry. I found my mistake - I had not referenced the result column at the end of the line to the Workbook and sheet. It should have been:

Please Login or Register  to view this content.

This now works ok.

Paul